Dataset statistics
| Number of variables | 39 |
|---|---|
| Number of observations | 1004 |
| Missing cells | 37860 |
| Missing cells (%) | 96.7% |
| Duplicate rows | 1 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 306.0 KiB |
| Average record size in memory | 312.1 B |
Variable types
| Categorical | 1 |
|---|---|
| Numeric | 38 |
| Dataset has 1 (0.1%) duplicate rows | Duplicates |
EQ is highly overall correlated with Digital_Working_cost and 10 other fields | High correlation |
Social_Search_Impressions is highly overall correlated with Social_Search_Working_cost and 4 other fields | High correlation |
Social_Search_Working_cost is highly overall correlated with Social_Search_Impressions and 6 other fields | High correlation |
Digital_Impressions is highly overall correlated with Digital_Working_cost and 6 other fields | High correlation |
Digital_Working_cost is highly overall correlated with EQ and 12 other fields | High correlation |
Print_Impressions.Ads40 is highly overall correlated with EQ and 12 other fields | High correlation |
Print_Working_Cost.Ads50 is highly overall correlated with Digital_Impressions and 9 other fields | High correlation |
OOH_Impressions is highly overall correlated with Print_Impressions.Ads40 and 10 other fields | High correlation |
OOH_Working_Cost is highly overall correlated with OOH_Impressions and 6 other fields | High correlation |
SOS_pct is highly overall correlated with Period | High correlation |
Digital_Impressions_pct is highly overall correlated with EQ and 7 other fields | High correlation |
CCFOT is highly overall correlated with Period | High correlation |
Median_Temp is highly overall correlated with Social_Search_Impressions and 5 other fields | High correlation |
Median_Rainfall is highly overall correlated with OOH_Impressions and 5 other fields | High correlation |
Fuel_Price is highly overall correlated with EQ and 13 other fields | High correlation |
Inflation is highly overall correlated with EQ and 11 other fields | High correlation |
Trade_Invest is highly overall correlated with Digital_Impressions and 10 other fields | High correlation |
Brand_Equity is highly overall correlated with Digital_Impressions_pct and 8 other fields | High correlation |
Avg_EQ_Price is highly overall correlated with Any_Promo_pct_ACV and 10 other fields | High correlation |
Any_Promo_pct_ACV is highly overall correlated with Avg_EQ_Price and 6 other fields | High correlation |
Any_Feat_pct_ACV is highly overall correlated with EQ and 15 other fields | High correlation |
Any_Disp_pct_ACV is highly overall correlated with Avg_EQ_Price and 3 other fields | High correlation |
EQ_Base_Price is highly overall correlated with Digital_Working_cost and 11 other fields | High correlation |
Est_ACV_Selling is highly overall correlated with EQ and 13 other fields | High correlation |
pct_ACV is highly overall correlated with EQ and 12 other fields | High correlation |
Avg_no_of_Items is highly overall correlated with EQ and 5 other fields | High correlation |
pct_PromoMarketDollars_Category is highly overall correlated with Avg_EQ_Price and 6 other fields | High correlation |
RPI_Category is highly overall correlated with Brand_Equity and 10 other fields | High correlation |
Magazine_Impressions_pct is highly overall correlated with Social_Search_Working_cost and 12 other fields | High correlation |
TV_GRP is highly overall correlated with Social_Search_Working_cost and 4 other fields | High correlation |
Competitor1_RPI is highly overall correlated with OOH_Impressions and 11 other fields | High correlation |
Competitor2_RPI is highly overall correlated with Avg_EQ_Price and 7 other fields | High correlation |
Competitor3_RPI is highly overall correlated with Avg_EQ_Price and 7 other fields | High correlation |
Competitor4_RPI is highly overall correlated with Avg_EQ_Price and 9 other fields | High correlation |
EQ_Category is highly overall correlated with EQ and 7 other fields | High correlation |
EQ_Subcategory is highly overall correlated with Social_Search_Impressions and 7 other fields | High correlation |
pct_PromoMarketDollars_Subcategory is highly overall correlated with OOH_Impressions and 7 other fields | High correlation |
RPI_Subcategory is highly overall correlated with Brand_Equity and 8 other fields | High correlation |
Period is highly overall correlated with EQ and 37 other fields | High correlation |
Period has 965 (96.1%) missing values | Missing |
EQ has 965 (96.1%) missing values | Missing |
Social_Search_Impressions has 975 (97.1%) missing values | Missing |
Social_Search_Working_cost has 975 (97.1%) missing values | Missing |
Digital_Impressions has 978 (97.4%) missing values | Missing |
Digital_Working_cost has 979 (97.5%) missing values | Missing |
Print_Impressions.Ads40 has 966 (96.2%) missing values | Missing |
Print_Working_Cost.Ads50 has 966 (96.2%) missing values | Missing |
OOH_Impressions has 992 (98.8%) missing values | Missing |
OOH_Working_Cost has 995 (99.1%) missing values | Missing |
SOS_pct has 965 (96.1%) missing values | Missing |
Digital_Impressions_pct has 991 (98.7%) missing values | Missing |
CCFOT has 965 (96.1%) missing values | Missing |
Median_Temp has 965 (96.1%) missing values | Missing |
Median_Rainfall has 965 (96.1%) missing values | Missing |
Fuel_Price has 965 (96.1%) missing values | Missing |
Inflation has 965 (96.1%) missing values | Missing |
Trade_Invest has 965 (96.1%) missing values | Missing |
Brand_Equity has 965 (96.1%) missing values | Missing |
Avg_EQ_Price has 965 (96.1%) missing values | Missing |
Any_Promo_pct_ACV has 965 (96.1%) missing values | Missing |
Any_Feat_pct_ACV has 992 (98.8%) missing values | Missing |
Any_Disp_pct_ACV has 979 (97.5%) missing values | Missing |
EQ_Base_Price has 965 (96.1%) missing values | Missing |
Est_ACV_Selling has 965 (96.1%) missing values | Missing |
pct_ACV has 965 (96.1%) missing values | Missing |
Avg_no_of_Items has 965 (96.1%) missing values | Missing |
pct_PromoMarketDollars_Category has 965 (96.1%) missing values | Missing |
RPI_Category has 965 (96.1%) missing values | Missing |
Magazine_Impressions_pct has 991 (98.7%) missing values | Missing |
TV_GRP has 991 (98.7%) missing values | Missing |
Competitor1_RPI has 965 (96.1%) missing values | Missing |
Competitor2_RPI has 965 (96.1%) missing values | Missing |
Competitor3_RPI has 965 (96.1%) missing values | Missing |
Competitor4_RPI has 965 (96.1%) missing values | Missing |
EQ_Category has 965 (96.1%) missing values | Missing |
EQ_Subcategory has 965 (96.1%) missing values | Missing |
pct_PromoMarketDollars_Subcategory has 965 (96.1%) missing values | Missing |
RPI_Subcategory has 965 (96.1%) missing values | Missing |
Period is uniformly distributed | Uniform |
Reproduction
| Analysis started | 2024-03-11 08:47:16.529359 |
|---|---|
| Analysis finished | 2024-03-11 08:49:38.389716 |
| Duration | 2 minutes and 21.86 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
Period
Categorical
HIGH CORRELATION  MISSING  UNIFORM 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Memory size | 8.0 KiB |
| 2016 - Period:1 | 1 |
|---|---|
| 2018 - Period:8 | 1 |
| 2017 - Period:12 | 1 |
| 2017 - Period:13 | 1 |
| 2018 - Period:2 | 1 |
| Other values (34) |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 15.307692 |
| Min length | 15 |
Characters and Unicode
| Total characters | 597 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 39 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 2016 - Period:1 |
|---|---|
| 2nd row | 2016 - Period:2 |
| 3rd row | 2016 - Period:3 |
| 4th row | 2016 - Period:4 |
| 5th row | 2016 - Period:5 |
Common Values
| Value | Count | Frequency (%) |
| 2016 - Period:1 | 1 | 0.1% |
| 2018 - Period:8 | 1 | 0.1% |
| 2017 - Period:12 | 1 | 0.1% |
| 2017 - Period:13 | 1 | 0.1% |
| 2018 - Period:2 | 1 | 0.1% |
| 2018 - Period:3 | 1 | 0.1% |
| 2018 - Period:4 | 1 | 0.1% |
| 2018 - Period:5 | 1 | 0.1% |
| 2018 - Period:7 | 1 | 0.1% |
| 2018 - Period:9 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
Length
| Value | Count | Frequency (%) |
| 39 | ||
| 2016 | 13 | 11.1% |
| 2018 | 13 | 11.1% |
| 2017 | 13 | 11.1% |
| period:4 | 3 | 2.6% |
| period:6 | 3 | 2.6% |
| period:10 | 3 | 2.6% |
| period:9 | 3 | 2.6% |
| period:7 | 3 | 2.6% |
| period:5 | 3 | 2.6% |
| Other values (7) | 21 |
Most occurring characters
| Value | Count | Frequency (%) |
| 78 | ||
| 1 | 57 | |
| 2 | 45 | 7.5% |
| 0 | 42 | 7.0% |
| r | 39 | 6.5% |
| : | 39 | 6.5% |
| d | 39 | 6.5% |
| o | 39 | 6.5% |
| i | 39 | 6.5% |
| e | 39 | 6.5% |
| Other values (9) | 141 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 207 | |
| Lowercase Letter | 195 | |
| Space Separator | 78 | 13.1% |
| Other Punctuation | 39 | 6.5% |
| Uppercase Letter | 39 | 6.5% |
| Dash Punctuation | 39 | 6.5% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 57 | |
| 2 | 45 | |
| 0 | 42 | |
| 6 | 16 | 7.7% |
| 8 | 16 | 7.7% |
| 7 | 16 | 7.7% |
| 3 | 6 | 2.9% |
| 4 | 3 | 1.4% |
| 5 | 3 | 1.4% |
| 9 | 3 | 1.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 39 | |
| d | 39 | |
| o | 39 | |
| i | 39 | |
| e | 39 |
Space Separator
| Value | Count | Frequency (%) |
| 78 |
Other Punctuation
| Value | Count | Frequency (%) |
| : | 39 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 39 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 39 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 363 | |
| Latin | 234 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 78 | ||
| 1 | 57 | |
| 2 | 45 | |
| 0 | 42 | |
| : | 39 | |
| - | 39 | |
| 6 | 16 | 4.4% |
| 8 | 16 | 4.4% |
| 7 | 16 | 4.4% |
| 3 | 6 | 1.7% |
| Other values (3) | 9 | 2.5% |
Latin
| Value | Count | Frequency (%) |
| r | 39 | |
| d | 39 | |
| o | 39 | |
| i | 39 | |
| e | 39 | |
| P | 39 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 597 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 78 | ||
| 1 | 57 | |
| 2 | 45 | 7.5% |
| 0 | 42 | 7.0% |
| r | 39 | 6.5% |
| : | 39 | 6.5% |
| d | 39 | 6.5% |
| o | 39 | 6.5% |
| i | 39 | 6.5% |
| e | 39 | 6.5% |
| Other values (9) | 141 |
EQ
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 317.60746 |
| Minimum | 130.93736 |
|---|---|
| Maximum | 546.05308 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 130.93736 |
|---|---|
| 5-th percentile | 160.54057 |
| Q1 | 238.4726 |
| median | 286.70559 |
| Q3 | 388.93216 |
| 95-th percentile | 491.68232 |
| Maximum | 546.05308 |
| Range | 415.11572 |
| Interquartile range (IQR) | 150.45956 |
Descriptive statistics
| Standard deviation | 117.56609 |
|---|---|
| Coefficient of variation (CV) | 0.37016162 |
| Kurtosis | -1.0345288 |
| Mean | 317.60746 |
| Median Absolute Deviation (MAD) | 91.568325 |
| Skewness | 0.29451332 |
| Sum | 12386.691 |
| Variance | 13821.786 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 504.7849334 | 1 | 0.1% |
| 244.9313589 | 1 | 0.1% |
| 179.2925035 | 1 | 0.1% |
| 173.2373049 | 1 | 0.1% |
| 284.1832918 | 1 | 0.1% |
| 274.4307568 | 1 | 0.1% |
| 205.4999844 | 1 | 0.1% |
| 250.555064 | 1 | 0.1% |
| 284.8954797 | 1 | 0.1% |
| 175.4323186 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 130.9373608 | 1 | |
| 151.6422314 | 1 | |
| 161.529279 | 1 | |
| 168.1066651 | 1 | |
| 173.2373049 | 1 | |
| 175.4323186 | 1 | |
| 179.2925035 | 1 | |
| 193.3007544 | 1 | |
| 205.4999844 | 1 | |
| 237.7135844 | 1 |
| Value | Count | Frequency (%) |
| 546.0530843 | 1 | |
| 504.7849334 | 1 | |
| 490.2264774 | 1 | |
| 489.0574275 | 1 | |
| 487.8552994 | 1 | |
| 479.2446856 | 1 | |
| 477.0319938 | 1 | |
| 466.3992813 | 1 | |
| 464.9256065 | 1 | |
| 392.3264313 | 1 |
Social_Search_Impressions
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 29 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 975 |
| Missing (%) | 97.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11610388 |
| Minimum | 21600 |
|---|---|
| Maximum | 40397389 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 21600 |
|---|---|
| 5-th percentile | 565960.16 |
| Q1 | 3180503 |
| median | 9662476.8 |
| Q3 | 16791295 |
| 95-th percentile | 26473951 |
| Maximum | 40397389 |
| Range | 40375789 |
| Interquartile range (IQR) | 13610792 |
Descriptive statistics
| Standard deviation | 10077123 |
|---|---|
| Coefficient of variation (CV) | 0.86794026 |
| Kurtosis | 0.69766478 |
| Mean | 11610388 |
| Median Absolute Deviation (MAD) | 6832553.2 |
| Skewness | 0.96375438 |
| Sum | 3.3670124 × 108 |
| Variance | 1.015484 × 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3919100.6 | 1 | 0.1% |
| 15378465.6 | 1 | 0.1% |
| 2829923.6 | 1 | 0.1% |
| 21830378.8 | 1 | 0.1% |
| 1314877 | 1 | 0.1% |
| 1678740 | 1 | 0.1% |
| 3180503 | 1 | 0.1% |
| 16067933.4 | 1 | 0.1% |
| 40397389.4 | 1 | 0.1% |
| 26489230.8 | 1 | 0.1% |
| Other values (19) | 19 | 1.9% |
| (Missing) | 975 |
| Value | Count | Frequency (%) |
| 21600 | 1 | |
| 285755.2 | 1 | |
| 986267.6 | 1 | |
| 1314877 | 1 | |
| 1678740 | 1 | |
| 1989489.2 | 1 | |
| 2829923.6 | 1 | |
| 3180503 | 1 | |
| 3402795.8 | 1 | |
| 3919100.6 | 1 |
| Value | Count | Frequency (%) |
| 40397389.4 | 1 | |
| 26489230.8 | 1 | |
| 26451030.6 | 1 | |
| 25075933 | 1 | |
| 22401179 | 1 | |
| 21830378.8 | 1 | |
| 17438860.2 | 1 | |
| 16791295.4 | 1 | |
| 16067933.4 | 1 | |
| 15378465.6 | 1 |
Social_Search_Working_cost
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 29 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 975 |
| Missing (%) | 97.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 49178.994 |
| Minimum | 2006.674 |
|---|---|
| Maximum | 153276.59 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 2006.674 |
|---|---|
| 5-th percentile | 4052.4844 |
| Q1 | 19605.934 |
| median | 34039.141 |
| Q3 | 80510.769 |
| 95-th percentile | 120285.2 |
| Maximum | 153276.59 |
| Range | 151269.92 |
| Interquartile range (IQR) | 60904.835 |
Descriptive statistics
| Standard deviation | 42213.013 |
|---|---|
| Coefficient of variation (CV) | 0.85835454 |
| Kurtosis | -0.2244678 |
| Mean | 49178.994 |
| Median Absolute Deviation (MAD) | 28536.427 |
| Skewness | 0.82014064 |
| Sum | 1426190.8 |
| Variance | 1.7819385 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 24839.812 | 1 | 0.1% |
| 58338.89312 | 1 | 0.1% |
| 9938.170001 | 1 | 0.1% |
| 98309.5535 | 1 | 0.1% |
| 7398.658606 | 1 | 0.1% |
| 20713.458 | 1 | 0.1% |
| 36362.25299 | 1 | 0.1% |
| 101446.7048 | 1 | 0.1% |
| 132844.1983 | 1 | 0.1% |
| 80510.76945 | 1 | 0.1% |
| Other values (19) | 19 | 1.9% |
| (Missing) | 975 |
| Value | Count | Frequency (%) |
| 2006.674 | 1 | |
| 3713.646 | 1 | |
| 4560.742 | 1 | |
| 5232.968 | 1 | |
| 5502.714 | 1 | |
| 7398.658606 | 1 | |
| 9938.170001 | 1 | |
| 19605.934 | 1 | |
| 20061.632 | 1 | |
| 20713.458 | 1 |
| Value | Count | Frequency (%) |
| 153276.592 | 1 | |
| 132844.1983 | 1 | |
| 101446.7048 | 1 | |
| 99256.76343 | 1 | |
| 98309.5535 | 1 | |
| 97681.98396 | 1 | |
| 83166.37624 | 1 | |
| 80510.76945 | 1 | |
| 79887.514 | 1 | |
| 70851.44307 | 1 |
Digital_Impressions
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 26 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 978 |
| Missing (%) | 97.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3885467.6 |
| Minimum | 29892.2 |
|---|---|
| Maximum | 18300509 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 29892.2 |
|---|---|
| 5-th percentile | 32035.3 |
| Q1 | 328049.35 |
| median | 3033369.1 |
| Q3 | 5984218.2 |
| 95-th percentile | 8126916.9 |
| Maximum | 18300509 |
| Range | 18270616 |
| Interquartile range (IQR) | 5656168.8 |
Descriptive statistics
| Standard deviation | 4080376.9 |
|---|---|
| Coefficient of variation (CV) | 1.0501637 |
| Kurtosis | 4.9937876 |
| Mean | 3885467.6 |
| Median Absolute Deviation (MAD) | 2858967.7 |
| Skewness | 1.771853 |
| Sum | 1.0102216 × 108 |
| Variance | 1.6649476 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 37148.2 | 1 | 0.1% |
| 1850034.6 | 1 | 0.1% |
| 5454810 | 1 | 0.1% |
| 7324082.2 | 1 | 0.1% |
| 5621661.8 | 1 | 0.1% |
| 6464034 | 1 | 0.1% |
| 5871568.6 | 1 | 0.1% |
| 5686252.6 | 1 | 0.1% |
| 3006588.2 | 1 | 0.1% |
| 18300508.6 | 1 | 0.1% |
| Other values (16) | 16 | 1.6% |
| (Missing) | 978 |
| Value | Count | Frequency (%) |
| 29892.2 | 1 | |
| 30331 | 1 | |
| 37148.2 | 1 | |
| 50886.8 | 1 | |
| 63120.8 | 1 | |
| 153633.2 | 1 | |
| 253333.2 | 1 | |
| 552197.8 | 1 | |
| 1165477.6 | 1 | |
| 1815307.2 | 1 |
| Value | Count | Frequency (%) |
| 18300508.6 | 1 | |
| 8394528.4 | 1 | |
| 7324082.2 | 1 | |
| 7140598.2 | 1 | |
| 6985266.8 | 1 | |
| 6464034 | 1 | |
| 6021768 | 1 | |
| 5871568.6 | 1 | |
| 5686252.6 | 1 | |
| 5621661.8 | 1 |
Digital_Working_cost
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 25 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 979 |
| Missing (%) | 97.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 46622.924 |
| Minimum | 1800.344 |
|---|---|
| Maximum | 170507.76 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1800.344 |
|---|---|
| 5-th percentile | 2110.3424 |
| Q1 | 7591.644 |
| median | 31259.416 |
| Q3 | 70004.656 |
| 95-th percentile | 139235.33 |
| Maximum | 170507.76 |
| Range | 168707.42 |
| Interquartile range (IQR) | 62413.012 |
Descriptive statistics
| Standard deviation | 48093.264 |
|---|---|
| Coefficient of variation (CV) | 1.0315369 |
| Kurtosis | 0.5358079 |
| Mean | 46622.924 |
| Median Absolute Deviation (MAD) | 28078.528 |
| Skewness | 1.0806325 |
| Sum | 1165573.1 |
| Variance | 2.3129621 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2045.282 | 1 | 0.1% |
| 8292.645025 | 1 | 0.1% |
| 111398.2031 | 1 | 0.1% |
| 58293.07467 | 1 | 0.1% |
| 69705.63268 | 1 | 0.1% |
| 70004.65554 | 1 | 0.1% |
| 67940.37067 | 1 | 0.1% |
| 36791.8245 | 1 | 0.1% |
| 146194.6165 | 1 | 0.1% |
| 11915.13265 | 1 | 0.1% |
| Other values (15) | 15 | 1.5% |
| (Missing) | 979 |
| Value | Count | Frequency (%) |
| 1800.344 | 1 | |
| 2045.282 | 1 | |
| 2370.584 | 1 | |
| 3180.888 | 1 | |
| 3579.13 | 1 | |
| 3983.134 | 1 | |
| 7591.644 | 1 | |
| 7866.572 | 1 | |
| 8292.645025 | 1 | |
| 11915.13265 | 1 |
| Value | Count | Frequency (%) |
| 170507.7628 | 1 | |
| 146194.6165 | 1 | |
| 111398.2031 | 1 | |
| 99043.67197 | 1 | |
| 86689.57339 | 1 | |
| 74906.49837 | 1 | |
| 70004.65554 | 1 | |
| 69705.63268 | 1 | |
| 67940.37067 | 1 | |
| 58293.07467 | 1 |
Print_Impressions.Ads40
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 36 |
|---|---|
| Distinct (%) | 94.7% |
| Missing | 966 |
| Missing (%) | 96.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2074374.8 |
| Minimum | 1.4 × 10-5 |
|---|---|
| Maximum | 12058522 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1.4 × 10-5 |
|---|---|
| 5-th percentile | 1.6144 × 10-5 |
| Q1 | 1.66661 × 10-5 |
| median | 4155.4463 |
| Q3 | 1809348.8 |
| 95-th percentile | 10673039 |
| Maximum | 12058522 |
| Range | 12058522 |
| Interquartile range (IQR) | 1809348.8 |
Descriptive statistics
| Standard deviation | 3711857.5 |
|---|---|
| Coefficient of variation (CV) | 1.7893861 |
| Kurtosis | 1.3967727 |
| Mean | 2074374.8 |
| Median Absolute Deviation (MAD) | 4155.4463 |
| Skewness | 1.674983 |
| Sum | 78826243 |
| Variance | 1.3777886 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.66666 × 10-5 | 3 | 0.3% |
| 6567260.788 | 1 | 0.1% |
| 92755.49804 | 1 | 0.1% |
| 37102.19923 | 1 | 0.1% |
| 5936.35189 | 1 | 0.1% |
| 2374.540766 | 1 | 0.1% |
| 949.8163164 | 1 | 0.1% |
| 379.9265366 | 1 | 0.1% |
| 11113304.32 | 1 | 0.1% |
| 579721.8627 | 1 | 0.1% |
| Other values (26) | 26 | 2.6% |
| (Missing) | 966 |
| Value | Count | Frequency (%) |
| 1.4 × 10-5 | 1 | |
| 1.56 × 10-5 | 1 | |
| 1.624 × 10-5 | 1 | |
| 1.6496 × 10-5 | 1 | |
| 1.65984 × 10-5 | 1 | |
| 1.66394 × 10-5 | 1 | |
| 1.66557 × 10-5 | 1 | |
| 1.66623 × 10-5 | 1 | |
| 1.66649 × 10-5 | 1 | |
| 1.6666 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 12058521.73 | 1 | |
| 11113304.32 | 1 | |
| 10595345.26 | 1 | |
| 9058154.104 | 1 | |
| 8910371.9 | 1 | |
| 6651401 | 1 | |
| 6567260.788 | 1 | |
| 4823408.69 | 1 | |
| 3623261.642 | 1 | |
| 1929363.476 | 1 |
Print_Working_Cost.Ads50
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 38 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 966 |
| Missing (%) | 96.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35042.988 |
| Minimum | 1.5 × 10-5 |
|---|---|
| Maximum | 239751.41 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1.5 × 10-5 |
|---|---|
| 5-th percentile | 1.85625 × 10-5 |
| Q1 | 1.9991425 × 10-5 |
| median | 606.97033 |
| Q3 | 42995.89 |
| 95-th percentile | 185869.84 |
| Maximum | 239751.41 |
| Range | 239751.41 |
| Interquartile range (IQR) | 42995.89 |
Descriptive statistics
| Standard deviation | 62774.262 |
|---|---|
| Coefficient of variation (CV) | 1.7913501 |
| Kurtosis | 3.3965029 |
| Mean | 35042.988 |
| Median Absolute Deviation (MAD) | 606.97032 |
| Skewness | 2.0144463 |
| Sum | 1331633.6 |
| Variance | 3.9406079 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 98714.34522 | 1 | 0.1% |
| 6474.350036 | 1 | 0.1% |
| 3237.175028 | 1 | 0.1% |
| 809.293772 | 1 | 0.1% |
| 404.646896 | 1 | 0.1% |
| 202.323458 | 1 | 0.1% |
| 101.161739 | 1 | 0.1% |
| 87161.49044 | 1 | 0.1% |
| 97390.77261 | 1 | 0.1% |
| 25897.40009 | 1 | 0.1% |
| Other values (28) | 28 | 2.8% |
| (Missing) | 966 |
| Value | Count | Frequency (%) |
| 1.5 × 10-5 | 1 | |
| 1.75 × 10-5 | 1 | |
| 1.875 × 10-5 | 1 | |
| 1.9375 × 10-5 | 1 | |
| 1.96875 × 10-5 | 1 | |
| 1.98438 × 10-5 | 1 | |
| 1.99219 × 10-5 | 1 | |
| 1.99609 × 10-5 | 1 | |
| 1.99805 × 10-5 | 1 | |
| 1.99902 × 10-5 | 1 |
| Value | Count | Frequency (%) |
| 239751.4067 | 1 | |
| 207179.2005 | 1 | |
| 182109.3639 | 1 | |
| 120894.503 | 1 | |
| 103589.6003 | 1 | |
| 98714.34522 | 1 | |
| 97390.77261 | 1 | |
| 87161.49044 | 1 | |
| 51794.80015 | 1 | |
| 48695.38631 | 1 |
OOH_Impressions
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 12 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 992 |
| Missing (%) | 98.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.7955166 × 108 |
| Minimum | 28807.2 |
|---|---|
| Maximum | 3.1196561 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 28807.2 |
|---|---|
| 5-th percentile | 6274524.8 |
| Q1 | 22930694 |
| median | 96811038 |
| Q3 | 1.9219764 × 109 |
| 95-th percentile | 2.8963324 × 109 |
| Maximum | 3.1196561 × 109 |
| Range | 3.1196273 × 109 |
| Interquartile range (IQR) | 1.8990457 × 109 |
Descriptive statistics
| Standard deviation | 1.2146957 × 109 |
|---|---|
| Coefficient of variation (CV) | 1.2400527 |
| Kurtosis | -1.3010388 |
| Mean | 9.7955166 × 108 |
| Median Absolute Deviation (MAD) | 91104305 |
| Skewness | 0.70320932 |
| Sum | 1.175462 × 1010 |
| Variance | 1.4754857 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63009885 | 1 | 0.1% |
| 43253453.4 | 1 | 0.1% |
| 23326167 | 1 | 0.1% |
| 11384657.4 | 1 | 0.1% |
| 28807.2 | 1 | 0.1% |
| 1876621874 | 1 | 0.1% |
| 3119656147 | 1 | 0.1% |
| 2713612918 | 1 | 0.1% |
| 2058039840 | 1 | 0.1% |
| 21744273.6 | 1 | 0.1% |
| Other values (2) | 2 | 0.2% |
| (Missing) | 992 |
| Value | Count | Frequency (%) |
| 28807.2 | 1 | |
| 11384657.4 | 1 | |
| 21744273.6 | 1 | |
| 23326167 | 1 | |
| 43253453.4 | 1 | |
| 63009885 | 1 | |
| 130612190.4 | 1 | |
| 1693329719 | 1 | |
| 1876621874 | 1 | |
| 2058039840 | 1 |
| Value | Count | Frequency (%) |
| 3119656147 | 1 | |
| 2713612918 | 1 | |
| 2058039840 | 1 | |
| 1876621874 | 1 | |
| 1693329719 | 1 | |
| 130612190.4 | 1 | |
| 63009885 | 1 | |
| 43253453.4 | 1 | |
| 23326167 | 1 | |
| 21744273.6 | 1 |
OOH_Working_Cost
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 9 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 995 |
| Missing (%) | 99.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2740891.9 |
| Minimum | 350.55059 |
|---|---|
| Maximum | 8617309.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 350.55059 |
|---|---|
| 5-th percentile | 33726.33 |
| Q1 | 136100.77 |
| median | 2115462.3 |
| Q3 | 5076808.8 |
| 95-th percentile | 7260156.7 |
| Maximum | 8617309.4 |
| Range | 8616958.8 |
| Interquartile range (IQR) | 4940708 |
Descriptive statistics
| Standard deviation | 3041383.9 |
|---|---|
| Coefficient of variation (CV) | 1.1096329 |
| Kurtosis | -0.037632488 |
| Mean | 2740891.9 |
| Median Absolute Deviation (MAD) | 2031672.3 |
| Skewness | 0.90969066 |
| Sum | 24668028 |
| Variance | 9.2500159 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 300082.9333 | 1 | 0.1% |
| 350.5505882 | 1 | 0.1% |
| 5224427.6 | 1 | 0.1% |
| 8617309.4 | 1 | 0.1% |
| 5076808.8 | 1 | 0.1% |
| 3113695.2 | 1 | 0.1% |
| 83790 | 1 | 0.1% |
| 136100.7655 | 1 | 0.1% |
| 2115462.3 | 1 | 0.1% |
| (Missing) | 995 |
| Value | Count | Frequency (%) |
| 350.5505882 | 1 | |
| 83790 | 1 | |
| 136100.7655 | 1 | |
| 300082.9333 | 1 | |
| 2115462.3 | 1 | |
| 3113695.2 | 1 | |
| 5076808.8 | 1 | |
| 5224427.6 | 1 | |
| 8617309.4 | 1 |
| Value | Count | Frequency (%) |
| 8617309.4 | 1 | |
| 5224427.6 | 1 | |
| 5076808.8 | 1 | |
| 3113695.2 | 1 | |
| 2115462.3 | 1 | |
| 300082.9333 | 1 | |
| 136100.7655 | 1 | |
| 83790 | 1 | |
| 350.5505882 | 1 |
SOS_pct
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.439476 |
| Minimum | 0.10285812 |
|---|---|
| Maximum | 47.442188 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.10285812 |
|---|---|
| 5-th percentile | 0.19094107 |
| Q1 | 0.98992606 |
| median | 9.2091035 |
| Q3 | 17.300709 |
| 95-th percentile | 31.522151 |
| Maximum | 47.442188 |
| Range | 47.33933 |
| Interquartile range (IQR) | 16.310782 |
Descriptive statistics
| Standard deviation | 11.340795 |
|---|---|
| Coefficient of variation (CV) | 0.99137363 |
| Kurtosis | 1.2258052 |
| Mean | 11.439476 |
| Median Absolute Deviation (MAD) | 8.6310946 |
| Skewness | 1.1266156 |
| Sum | 446.13957 |
| Variance | 128.61363 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.446882968 | 1 | 0.1% |
| 11.59993113 | 1 | 0.1% |
| 9.209103499 | 1 | 0.1% |
| 31.3712309 | 1 | 0.1% |
| 22.39294385 | 1 | 0.1% |
| 0.40785098 | 1 | 0.1% |
| 0.297397214 | 1 | 0.1% |
| 0.451805647 | 1 | 0.1% |
| 19.13840726 | 1 | 0.1% |
| 14.09567781 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.102858117 | 1 | |
| 0.172487208 | 1 | |
| 0.192991497 | 1 | |
| 0.249054996 | 1 | |
| 0.280501687 | 1 | |
| 0.297397214 | 1 | |
| 0.40785098 | 1 | |
| 0.408557805 | 1 | |
| 0.451805647 | 1 | |
| 0.5780089 | 1 |
| Value | Count | Frequency (%) |
| 47.44218767 | 1 | |
| 32.88043026 | 1 | |
| 31.3712309 | 1 | |
| 28.52949334 | 1 | |
| 24.44399433 | 1 | |
| 22.93253391 | 1 | |
| 22.39294385 | 1 | |
| 21.1631708 | 1 | |
| 21.07852061 | 1 | |
| 19.13840726 | 1 |
Digital_Impressions_pct
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 13 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 991 |
| Missing (%) | 98.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.549174 |
| Minimum | 0.00385256 |
|---|---|
| Maximum | 88.182705 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.00385256 |
|---|---|
| 5-th percentile | 0.0095531534 |
| Q1 | 0.0598269 |
| median | 1.2424036 |
| Q3 | 9.1765255 |
| 95-th percentile | 57.82503 |
| Maximum | 88.182705 |
| Range | 88.178852 |
| Interquartile range (IQR) | 9.1166986 |
Descriptive statistics
| Standard deviation | 25.11027 |
|---|---|
| Coefficient of variation (CV) | 2.0009499 |
| Kurtosis | 7.6154265 |
| Mean | 12.549174 |
| Median Absolute Deviation (MAD) | 1.2385511 |
| Skewness | 2.7028784 |
| Sum | 163.13927 |
| Variance | 630.52565 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.828396226 | 1 | 0.1% |
| 0.00385256 | 1 | 0.1% |
| 0.013353549 | 1 | 0.1% |
| 9.176525529 | 1 | 0.1% |
| 4.272028429 | 1 | 0.1% |
| 0.737375727 | 1 | 0.1% |
| 0.522356027 | 1 | 0.1% |
| 1.242403621 | 1 | 0.1% |
| 37.58658072 | 1 | 0.1% |
| 88.18270465 | 1 | 0.1% |
| Other values (3) | 3 | 0.3% |
| (Missing) | 991 |
| Value | Count | Frequency (%) |
| 0.00385256 | 1 | |
| 0.013353549 | 1 | |
| 0.045347224 | 1 | |
| 0.0598269 | 1 | |
| 0.522356027 | 1 | |
| 0.737375727 | 1 | |
| 1.242403621 | 1 | |
| 3.828396226 | 1 | |
| 4.272028429 | 1 | |
| 9.176525529 | 1 |
| Value | Count | Frequency (%) |
| 88.18270465 | 1 | |
| 37.58658072 | 1 | |
| 17.46851683 | 1 | |
| 9.176525529 | 1 | |
| 4.272028429 | 1 | |
| 3.828396226 | 1 | |
| 1.242403621 | 1 | |
| 0.737375727 | 1 | |
| 0.522356027 | 1 | |
| 0.0598269 | 1 |
CCFOT
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 19 |
|---|---|
| Distinct (%) | 48.7% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 87.957889 |
| Minimum | 20 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 60.720977 |
| Q1 | 81.951531 |
| median | 100 |
| Q3 | 100 |
| 95-th percentile | 100 |
| Maximum | 100 |
| Range | 80 |
| Interquartile range (IQR) | 18.048469 |
Descriptive statistics
| Standard deviation | 18.673922 |
|---|---|
| Coefficient of variation (CV) | 0.21230525 |
| Kurtosis | 4.4552095 |
| Mean | 87.957889 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.0181542 |
| Sum | 3430.3577 |
| Variance | 348.71536 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 100 | 21 | 2.1% |
| 87.5 | 1 | 0.1% |
| 83.33333333 | 1 | 0.1% |
| 35.71428571 | 1 | 0.1% |
| 63.49949816 | 1 | 0.1% |
| 72.13114754 | 1 | 0.1% |
| 66.66666667 | 1 | 0.1% |
| 70.58823529 | 1 | 0.1% |
| 81.25 | 1 | 0.1% |
| 20 | 1 | 0.1% |
| Other values (9) | 9 | 0.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 20 | 1 | |
| 35.71428571 | 1 | |
| 63.49949816 | 1 | |
| 63.84083045 | 1 | |
| 66.66666667 | 1 | |
| 69.56521739 | 1 | |
| 70.58823529 | 1 | |
| 72.13114754 | 1 | |
| 78.57142857 | 1 | |
| 81.25 | 1 |
| Value | Count | Frequency (%) |
| 100 | 21 | |
| 96.42857143 | 1 | 0.1% |
| 96 | 1 | 0.1% |
| 90 | 1 | 0.1% |
| 88 | 1 | 0.1% |
| 87.5 | 1 | 0.1% |
| 84.61538462 | 1 | 0.1% |
| 83.33333333 | 1 | 0.1% |
| 82.65306122 | 1 | 0.1% |
| 81.25 | 1 | 0.1% |
Median_Temp
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 37 |
|---|---|
| Distinct (%) | 94.9% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55.785897 |
| Minimum | 29.95 |
|---|---|
| Maximum | 77.35 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 29.95 |
|---|---|
| 5-th percentile | 34.4575 |
| Q1 | 42.25 |
| median | 57.25 |
| Q3 | 71.075 |
| 95-th percentile | 75.91 |
| Maximum | 77.35 |
| Range | 47.4 |
| Interquartile range (IQR) | 28.825 |
Descriptive statistics
| Standard deviation | 15.656995 |
|---|---|
| Coefficient of variation (CV) | 0.28066225 |
| Kurtosis | -1.5181517 |
| Mean | 55.785897 |
| Median Absolute Deviation (MAD) | 13.85 |
| Skewness | -0.060064019 |
| Sum | 2175.65 |
| Variance | 245.14151 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 46.7 | 2 | 0.2% |
| 75.85 | 2 | 0.2% |
| 32.95 | 1 | 0.1% |
| 75.75 | 1 | 0.1% |
| 44.05 | 1 | 0.1% |
| 36.25 | 1 | 0.1% |
| 37.55 | 1 | 0.1% |
| 39.9 | 1 | 0.1% |
| 45.9 | 1 | 0.1% |
| 62.425 | 1 | 0.1% |
| Other values (27) | 27 | 2.7% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 29.95 | 1 | |
| 32.95 | 1 | |
| 34.625 | 1 | |
| 35.45 | 1 | |
| 35.5 | 1 | |
| 35.875 | 1 | |
| 36.25 | 1 | |
| 37.55 | 1 | |
| 39.9 | 1 | |
| 40.95 | 1 |
| Value | Count | Frequency (%) |
| 77.35 | 1 | |
| 76.45 | 1 | |
| 75.85 | 2 | |
| 75.75 | 1 | |
| 75.05 | 1 | |
| 74.25 | 1 | |
| 73.7 | 1 | |
| 71.4 | 1 | |
| 71.1 | 1 | |
| 71.05 | 1 |
Median_Rainfall
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.39237179 |
| Minimum | 0.095 |
|---|---|
| Maximum | 0.74 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.095 |
|---|---|
| 5-th percentile | 0.1275 |
| Q1 | 0.2775 |
| median | 0.395 |
| Q3 | 0.53 |
| 95-th percentile | 0.61075 |
| Maximum | 0.74 |
| Range | 0.645 |
| Interquartile range (IQR) | 0.2525 |
Descriptive statistics
| Standard deviation | 0.16703977 |
|---|---|
| Coefficient of variation (CV) | 0.42571809 |
| Kurtosis | -0.91979688 |
| Mean | 0.39237179 |
| Median Absolute Deviation (MAD) | 0.125 |
| Skewness | -0.10104006 |
| Sum | 15.3025 |
| Variance | 0.027902286 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.515 | 1 | 0.1% |
| 0.61 | 1 | 0.1% |
| 0.165 | 1 | 0.1% |
| 0.19 | 1 | 0.1% |
| 0.49 | 1 | 0.1% |
| 0.315 | 1 | 0.1% |
| 0.33 | 1 | 0.1% |
| 0.395 | 1 | 0.1% |
| 0.545 | 1 | 0.1% |
| 0.59 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.095 | 1 | |
| 0.105 | 1 | |
| 0.13 | 1 | |
| 0.155 | 1 | |
| 0.16 | 1 | |
| 0.165 | 1 | |
| 0.19 | 1 | |
| 0.24 | 1 | |
| 0.2475 | 1 | |
| 0.27 | 1 |
| Value | Count | Frequency (%) |
| 0.74 | 1 | |
| 0.6175 | 1 | |
| 0.61 | 1 | |
| 0.6 | 1 | |
| 0.59 | 1 | |
| 0.5725 | 1 | |
| 0.5675 | 1 | |
| 0.56 | 1 | |
| 0.555 | 1 | |
| 0.545 | 1 |
Fuel_Price
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.193513 |
| Minimum | 7.473 |
|---|---|
| Maximum | 12.286 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 7.473 |
|---|---|
| 5-th percentile | 8.2035 |
| Q1 | 9.452 |
| median | 10.03 |
| Q3 | 10.938 |
| 95-th percentile | 11.8101 |
| Maximum | 12.286 |
| Range | 4.813 |
| Interquartile range (IQR) | 1.486 |
Descriptive statistics
| Standard deviation | 1.1567675 |
|---|---|
| Coefficient of variation (CV) | 0.11348075 |
| Kurtosis | -0.35280708 |
| Mean | 10.193513 |
| Median Absolute Deviation (MAD) | 0.753 |
| Skewness | -0.13635852 |
| Sum | 397.547 |
| Variance | 1.338111 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8.226 | 1 | 0.1% |
| 11.708 | 1 | 0.1% |
| 10.71 | 1 | 0.1% |
| 10.375 | 1 | 0.1% |
| 10.876 | 1 | 0.1% |
| 10.738 | 1 | 0.1% |
| 11.255 | 1 | 0.1% |
| 11.784 | 1 | 0.1% |
| 11.732 | 1 | 0.1% |
| 11.63 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 7.473 | 1 | |
| 8.001 | 1 | |
| 8.226 | 1 | |
| 8.767 | 1 | |
| 9.148 | 1 | |
| 9.18 | 1 | |
| 9.225 | 1 | |
| 9.277 | 1 | |
| 9.331 | 1 | |
| 9.442 | 1 |
| Value | Count | Frequency (%) |
| 12.286 | 1 | |
| 12.045 | 1 | |
| 11.784 | 1 | |
| 11.766 | 1 | |
| 11.732 | 1 | |
| 11.708 | 1 | |
| 11.703 | 1 | |
| 11.63 | 1 | |
| 11.255 | 1 | |
| 10.943 | 1 |
Inflation
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.017953846 |
| Minimum | 0.007832481 |
|---|---|
| Maximum | 0.026883641 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.007832481 |
|---|---|
| 5-th percentile | 0.0084435481 |
| Q1 | 0.014475 |
| median | 0.018696774 |
| Q3 | 0.021871544 |
| 95-th percentile | 0.02620243 |
| Maximum | 0.026883641 |
| Range | 0.01905116 |
| Interquartile range (IQR) | 0.007396544 |
Descriptive statistics
| Standard deviation | 0.0055662208 |
|---|---|
| Coefficient of variation (CV) | 0.31002943 |
| Kurtosis | -0.84921463 |
| Mean | 0.017953846 |
| Median Absolute Deviation (MAD) | 0.003712365 |
| Skewness | -0.35036103 |
| Sum | 0.7002 |
| Variance | 3.0982814 × 10-5 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.013258065 | 1 | 0.1% |
| 0.025758065 | 1 | 0.1% |
| 0.020427957 | 1 | 0.1% |
| 0.01973871 | 1 | 0.1% |
| 0.021613825 | 1 | 0.1% |
| 0.021428111 | 1 | 0.1% |
| 0.022549032 | 1 | 0.1% |
| 0.02454129 | 1 | 0.1% |
| 0.026715914 | 1 | 0.1% |
| 0.023499355 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.007832481 | 1 | |
| 0.008283871 | 1 | |
| 0.00846129 | 1 | |
| 0.009290323 | 1 | |
| 0.009546344 | 1 | |
| 0.009938487 | 1 | |
| 0.010034301 | 1 | |
| 0.011021505 | 1 | |
| 0.013258065 | 1 | |
| 0.013965591 | 1 |
| Value | Count | Frequency (%) |
| 0.026883641 | 1 | |
| 0.026715914 | 1 | |
| 0.026145376 | 1 | |
| 0.025758065 | 1 | |
| 0.02454129 | 1 | |
| 0.023499355 | 1 | |
| 0.022580645 | 1 | |
| 0.022549032 | 1 | |
| 0.022502581 | 1 | |
| 0.022129263 | 1 |
Trade_Invest
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13698.1 |
| Minimum | 365.43 |
|---|---|
| Maximum | 61675.322 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 365.43 |
|---|---|
| 5-th percentile | 448.288 |
| Q1 | 772.145 |
| median | 1168.95 |
| Q3 | 28613.27 |
| 95-th percentile | 53257.115 |
| Maximum | 61675.322 |
| Range | 61309.892 |
| Interquartile range (IQR) | 27841.125 |
Descriptive statistics
| Standard deviation | 19137.708 |
|---|---|
| Coefficient of variation (CV) | 1.3971068 |
| Kurtosis | -0.14427892 |
| Mean | 13698.1 |
| Median Absolute Deviation (MAD) | 778.37 |
| Skewness | 1.1414006 |
| Sum | 534225.89 |
| Variance | 3.6625187 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 42744.25684 | 1 | 0.1% |
| 1263.44 | 1 | 0.1% |
| 1158.19 | 1 | 0.1% |
| 703.52 | 1 | 0.1% |
| 4672.32 | 1 | 0.1% |
| 1987.18 | 1 | 0.1% |
| 824.64 | 1 | 0.1% |
| 365.43 | 1 | 0.1% |
| 1041.39 | 1 | 0.1% |
| 566.47 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 365.43 | 1 | |
| 390.58 | 1 | |
| 454.7 | 1 | |
| 494.75 | 1 | |
| 566.47 | 1 | |
| 571.28 | 1 | |
| 602.87 | 1 | |
| 657.53 | 1 | |
| 703.52 | 1 | |
| 741.2 | 1 |
| Value | Count | Frequency (%) |
| 61675.32162 | 1 | |
| 53637.19215 | 1 | |
| 53214.88476 | 1 | |
| 42744.25684 | 1 | |
| 40945.74781 | 1 | |
| 40458.59237 | 1 | |
| 36290.43956 | 1 | |
| 35020.00758 | 1 | |
| 34852.14166 | 1 | |
| 31883.33016 | 1 |
Brand_Equity
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 21 |
|---|---|
| Distinct (%) | 53.8% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 43.343031 |
| Minimum | 42.14 |
|---|---|
| Maximum | 44.45 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 42.14 |
|---|---|
| 5-th percentile | 42.14 |
| Q1 | 42.663214 |
| median | 43.543571 |
| Q3 | 43.992857 |
| 95-th percentile | 44.45 |
| Maximum | 44.45 |
| Range | 2.31 |
| Interquartile range (IQR) | 1.3296429 |
Descriptive statistics
| Standard deviation | 0.77374298 |
|---|---|
| Coefficient of variation (CV) | 0.017851612 |
| Kurtosis | -1.4236828 |
| Mean | 43.343031 |
| Median Absolute Deviation (MAD) | 0.75642857 |
| Skewness | -0.13777038 |
| Sum | 1690.3782 |
| Variance | 0.59867819 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44.3 | 3 | 0.3% |
| 42.14 | 3 | 0.3% |
| 42.78 | 3 | 0.3% |
| 43.61 | 3 | 0.3% |
| 44.45 | 3 | 0.3% |
| 42.41 | 3 | 0.3% |
| 43.85 | 2 | 0.2% |
| 44.17 | 2 | 0.2% |
| 42.33 | 2 | 0.2% |
| 42.88 | 2 | 0.2% |
| Other values (11) | 13 | 1.3% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 42.14 | 3 | |
| 42.33 | 2 | |
| 42.41 | 3 | |
| 42.4425 | 1 | 0.1% |
| 42.605 | 1 | 0.1% |
| 42.72142857 | 1 | 0.1% |
| 42.78 | 3 | |
| 42.88 | 2 | |
| 43.37 | 2 | |
| 43.43 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 44.45 | 3 | |
| 44.3 | 3 | |
| 44.20714286 | 1 | 0.1% |
| 44.17 | 2 | |
| 44.00714286 | 1 | 0.1% |
| 43.97857143 | 1 | 0.1% |
| 43.85 | 2 | |
| 43.79 | 2 | |
| 43.61 | 3 | |
| 43.59285714 | 1 | 0.1% |
Avg_EQ_Price
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.152324 |
| Minimum | 44.782569 |
|---|---|
| Maximum | 60.677869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 44.782569 |
|---|---|
| 5-th percentile | 46.536848 |
| Q1 | 49.585045 |
| median | 51.268984 |
| Q3 | 54.223745 |
| 95-th percentile | 60.047535 |
| Maximum | 60.677869 |
| Range | 15.8953 |
| Interquartile range (IQR) | 4.6386996 |
Descriptive statistics
| Standard deviation | 3.840841 |
|---|---|
| Coefficient of variation (CV) | 0.073646594 |
| Kurtosis | 0.1860926 |
| Mean | 52.152324 |
| Median Absolute Deviation (MAD) | 2.2029087 |
| Skewness | 0.57959274 |
| Sum | 2033.9406 |
| Variance | 14.75206 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 49.09144714 | 1 | 0.1% |
| 47.36709861 | 1 | 0.1% |
| 60.55213491 | 1 | 0.1% |
| 60.67786872 | 1 | 0.1% |
| 55.71559339 | 1 | 0.1% |
| 45.75784366 | 1 | 0.1% |
| 51.8931499 | 1 | 0.1% |
| 49.79009438 | 1 | 0.1% |
| 44.78256864 | 1 | 0.1% |
| 53.59841379 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 44.78256864 | 1 | |
| 45.75784366 | 1 | |
| 46.62340387 | 1 | |
| 47.36709861 | 1 | |
| 48.99297174 | 1 | |
| 49.0576119 | 1 | |
| 49.09144714 | 1 | |
| 49.30885217 | 1 | |
| 49.3675143 | 1 | |
| 49.37999598 | 1 |
| Value | Count | Frequency (%) |
| 60.67786872 | 1 | |
| 60.55213491 | 1 | |
| 59.99146871 | 1 | |
| 58.94417911 | 1 | |
| 57.95709697 | 1 | |
| 55.71559339 | 1 | |
| 54.82475011 | 1 | |
| 54.75500778 | 1 | |
| 54.55110748 | 1 | |
| 54.30927518 | 1 |
Any_Promo_pct_ACV
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.0838036 |
| Minimum | 0.32864491 |
|---|---|
| Maximum | 16.538448 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.32864491 |
|---|---|
| 5-th percentile | 0.53342091 |
| Q1 | 5.618422 |
| median | 7.7591016 |
| Q3 | 8.7218865 |
| 95-th percentile | 13.175593 |
| Maximum | 16.538448 |
| Range | 16.209803 |
| Interquartile range (IQR) | 3.1034645 |
Descriptive statistics
| Standard deviation | 3.6692636 |
|---|---|
| Coefficient of variation (CV) | 0.5179793 |
| Kurtosis | 0.33774752 |
| Mean | 7.0838036 |
| Median Absolute Deviation (MAD) | 1.6568361 |
| Skewness | -0.006450771 |
| Sum | 276.26834 |
| Variance | 13.463496 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.691793869 | 1 | 0.1% |
| 7.713256866 | 1 | 0.1% |
| 0.328644909 | 1 | 0.1% |
| 0.538218852 | 1 | 0.1% |
| 16.53844835 | 1 | 0.1% |
| 13.12176418 | 1 | 0.1% |
| 8.603562298 | 1 | 0.1% |
| 8.34197587 | 1 | 0.1% |
| 8.641116382 | 1 | 0.1% |
| 1.793797042 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.328644909 | 1 | |
| 0.490239408 | 1 | |
| 0.538218852 | 1 | |
| 1.340541225 | 1 | |
| 1.775007406 | 1 | |
| 1.793797042 | 1 | |
| 2.732962487 | 1 | |
| 3.087214438 | 1 | |
| 3.63844938 | 1 | |
| 5.176683634 | 1 |
| Value | Count | Frequency (%) |
| 16.53844835 | 1 | |
| 13.66005556 | 1 | |
| 13.12176418 | 1 | |
| 11.696305 | 1 | |
| 9.791996605 | 1 | |
| 9.791259803 | 1 | |
| 9.691793869 | 1 | |
| 9.415937736 | 1 | |
| 8.972686855 | 1 | |
| 8.802656562 | 1 |
Any_Feat_pct_ACV
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 12 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 992 |
| Missing (%) | 98.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.2228113 |
| Minimum | 1.6339892 |
|---|---|
| Maximum | 5.8449733 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1.6339892 |
|---|---|
| 5-th percentile | 3.5605112 |
| Q1 | 5.4296885 |
| median | 5.5705798 |
| Q3 | 5.6774542 |
| 95-th percentile | 5.7902716 |
| Maximum | 5.8449733 |
| Range | 4.2109841 |
| Interquartile range (IQR) | 0.2477657 |
Descriptive statistics
| Standard deviation | 1.1497262 |
|---|---|
| Coefficient of variation (CV) | 0.22013551 |
| Kurtosis | 10.960394 |
| Mean | 5.2228113 |
| Median Absolute Deviation (MAD) | 0.11058637 |
| Skewness | -3.2627388 |
| Sum | 62.673736 |
| Variance | 1.3218704 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.633989247 | 1 | 0.1% |
| 5.136756476 | 1 | 0.1% |
| 5.154290993 | 1 | 0.1% |
| 5.559574532 | 1 | 0.1% |
| 5.550839042 | 1 | 0.1% |
| 5.521487651 | 1 | 0.1% |
| 5.582391396 | 1 | 0.1% |
| 5.844973325 | 1 | 0.1% |
| 5.745515574 | 1 | 0.1% |
| 5.673742193 | 1 | 0.1% |
| Other values (2) | 2 | 0.2% |
| (Missing) | 992 |
| Value | Count | Frequency (%) |
| 1.633989247 | 1 | |
| 5.136756476 | 1 | |
| 5.154290993 | 1 | |
| 5.521487651 | 1 | |
| 5.550839042 | 1 | |
| 5.559574532 | 1 | |
| 5.581585079 | 1 | |
| 5.582391396 | 1 | |
| 5.673742193 | 1 | |
| 5.688590151 | 1 |
| Value | Count | Frequency (%) |
| 5.844973325 | 1 | |
| 5.745515574 | 1 | |
| 5.688590151 | 1 | |
| 5.673742193 | 1 | |
| 5.582391396 | 1 | |
| 5.581585079 | 1 | |
| 5.559574532 | 1 | |
| 5.550839042 | 1 | |
| 5.521487651 | 1 | |
| 5.154290993 | 1 |
Any_Disp_pct_ACV
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 25 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 979 |
| Missing (%) | 97.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.5921389 |
| Minimum | 0.033275573 |
|---|---|
| Maximum | 7.9254236 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.033275573 |
|---|---|
| 5-th percentile | 0.039444116 |
| Q1 | 0.25103412 |
| median | 1.0410422 |
| Q3 | 1.7613516 |
| 95-th percentile | 4.2252981 |
| Maximum | 7.9254236 |
| Range | 7.892148 |
| Interquartile range (IQR) | 1.5103175 |
Descriptive statistics
| Standard deviation | 1.8551848 |
|---|---|
| Coefficient of variation (CV) | 1.1652154 |
| Kurtosis | 4.6141214 |
| Mean | 1.5921389 |
| Median Absolute Deviation (MAD) | 0.7900081 |
| Skewness | 1.9900438 |
| Sum | 39.803473 |
| Variance | 3.4417106 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.688895637 | 1 | 0.1% |
| 0.044761006 | 1 | 0.1% |
| 1.761351571 | 1 | 0.1% |
| 0.294481475 | 1 | 0.1% |
| 4.273441727 | 1 | 0.1% |
| 1.041042224 | 1 | 0.1% |
| 0.972309382 | 1 | 0.1% |
| 0.976356202 | 1 | 0.1% |
| 1.871936212 | 1 | 0.1% |
| 1.136835226 | 1 | 0.1% |
| Other values (15) | 15 | 1.5% |
| (Missing) | 979 |
| Value | Count | Frequency (%) |
| 0.033275573 | 1 | |
| 0.038114894 | 1 | |
| 0.044761006 | 1 | |
| 0.14777156 | 1 | |
| 0.170730805 | 1 | |
| 0.218207121 | 1 | |
| 0.251034119 | 1 | |
| 0.294481475 | 1 | |
| 0.425449354 | 1 | |
| 0.962303407 | 1 |
| Value | Count | Frequency (%) |
| 7.925423602 | 1 | |
| 4.273441727 | 1 | |
| 4.032723608 | 1 | |
| 3.894863652 | 1 | |
| 3.551042056 | 1 | |
| 1.871936212 | 1 | |
| 1.761351571 | 1 | |
| 1.688895637 | 1 | |
| 1.687951925 | 1 | |
| 1.315427875 | 1 |
EQ_Base_Price
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.535196 |
| Minimum | 1.423408 |
|---|---|
| Maximum | 1.7302018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1.423408 |
|---|---|
| 5-th percentile | 1.4271776 |
| Q1 | 1.4547766 |
| median | 1.493424 |
| Q3 | 1.6025148 |
| 95-th percentile | 1.7014765 |
| Maximum | 1.7302018 |
| Range | 0.3067938 |
| Interquartile range (IQR) | 0.14773812 |
Descriptive statistics
| Standard deviation | 0.094601254 |
|---|---|
| Coefficient of variation (CV) | 0.061621613 |
| Kurtosis | -1.0516885 |
| Mean | 1.535196 |
| Median Absolute Deviation (MAD) | 0.055471076 |
| Skewness | 0.56741719 |
| Sum | 59.872644 |
| Variance | 0.0089493973 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.427532412 | 1 | 0.1% |
| 1.423984414 | 1 | 0.1% |
| 1.701360752 | 1 | 0.1% |
| 1.702518409 | 1 | 0.1% |
| 1.637888315 | 1 | 0.1% |
| 1.490420969 | 1 | 0.1% |
| 1.461149732 | 1 | 0.1% |
| 1.455720867 | 1 | 0.1% |
| 1.450412242 | 1 | 0.1% |
| 1.491545287 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 1.423408014 | 1 | |
| 1.423984414 | 1 | |
| 1.427532412 | 1 | |
| 1.428327771 | 1 | |
| 1.437952918 | 1 | |
| 1.438995139 | 1 | |
| 1.442716305 | 1 | |
| 1.443401166 | 1 | |
| 1.450412242 | 1 | |
| 1.453832416 | 1 |
| Value | Count | Frequency (%) |
| 1.730201818 | 1 | |
| 1.702518409 | 1 | |
| 1.701360752 | 1 | |
| 1.683306273 | 1 | |
| 1.676323287 | 1 | |
| 1.657504847 | 1 | |
| 1.647474304 | 1 | |
| 1.641433095 | 1 | |
| 1.637888315 | 1 | |
| 1.609794582 | 1 |
Est_ACV_Selling
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.8573975 × 109 |
| Minimum | 2.9046123 × 109 |
|---|---|
| Maximum | 8.7068975 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 2.9046123 × 109 |
|---|---|
| 5-th percentile | 3.1061112 × 109 |
| Q1 | 3.9960305 × 109 |
| median | 5.525007 × 109 |
| Q3 | 7.6909426 × 109 |
| 95-th percentile | 8.6837352 × 109 |
| Maximum | 8.7068975 × 109 |
| Range | 5.8022852 × 109 |
| Interquartile range (IQR) | 3.6949121 × 109 |
Descriptive statistics
| Standard deviation | 2.0679166 × 109 |
|---|---|
| Coefficient of variation (CV) | 0.35304357 |
| Kurtosis | -1.4681725 |
| Mean | 5.8573975 × 109 |
| Median Absolute Deviation (MAD) | 2.091092 × 109 |
| Skewness | 0.052624875 |
| Sum | 2.284385 × 1011 |
| Variance | 4.2762789 × 1018 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8696587915 | 1 | 0.1% |
| 3289530263 | 1 | 0.1% |
| 4743181459 | 1 | 0.1% |
| 4462125013 | 1 | 0.1% |
| 4885584886 | 1 | 0.1% |
| 4489806007 | 1 | 0.1% |
| 3400703123 | 1 | 0.1% |
| 3529935987 | 1 | 0.1% |
| 3277931800 | 1 | 0.1% |
| 3185984279 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 2904612335 | 1 | |
| 2937758346 | 1 | |
| 3124817100 | 1 | |
| 3185984279 | 1 | |
| 3214807831 | 1 | |
| 3277931800 | 1 | |
| 3289530263 | 1 | |
| 3397924709 | 1 | |
| 3400703123 | 1 | |
| 3529935987 | 1 |
| Value | Count | Frequency (%) |
| 8706897549 | 1 | |
| 8696587915 | 1 | |
| 8682307085 | 1 | |
| 8662698543 | 1 | |
| 8660288592 | 1 | |
| 8644518558 | 1 | |
| 8627353001 | 1 | |
| 8511934271 | 1 | |
| 7928216512 | 1 | |
| 7765786227 | 1 |
pct_ACV
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.383663 |
| Minimum | 13.036065 |
|---|---|
| Maximum | 39.441025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 13.036065 |
|---|---|
| 5-th percentile | 13.508119 |
| Q1 | 14.475919 |
| median | 24.556337 |
| Q3 | 32.504704 |
| 95-th percentile | 39.025764 |
| Maximum | 39.441025 |
| Range | 26.40496 |
| Interquartile range (IQR) | 18.028785 |
Descriptive statistics
| Standard deviation | 9.3573085 |
|---|---|
| Coefficient of variation (CV) | 0.36863508 |
| Kurtosis | -1.3996808 |
| Mean | 25.383663 |
| Median Absolute Deviation (MAD) | 9.9449411 |
| Skewness | 0.096592964 |
| Sum | 989.96285 |
| Variance | 87.559222 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 39.44102455 | 1 | 0.1% |
| 13.70158946 | 1 | 0.1% |
| 20.88503184 | 1 | 0.1% |
| 19.89274619 | 1 | 0.1% |
| 21.03597474 | 1 | 0.1% |
| 14.34044224 | 1 | 0.1% |
| 14.17660408 | 1 | 0.1% |
| 14.61139579 | 1 | 0.1% |
| 13.55059547 | 1 | 0.1% |
| 13.72856063 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 13.03606458 | 1 | |
| 13.12583198 | 1 | |
| 13.55059547 | 1 | |
| 13.57297273 | 1 | |
| 13.67638207 | 1 | |
| 13.70158946 | 1 | |
| 13.72856063 | 1 | |
| 14.08154163 | 1 | |
| 14.17660408 | 1 | |
| 14.34044224 | 1 |
| Value | Count | Frequency (%) |
| 39.44102455 | 1 | |
| 39.09772922 | 1 | |
| 39.01776821 | 1 | |
| 38.62956375 | 1 | |
| 38.41722445 | 1 | |
| 38.1351586 | 1 | |
| 37.94002737 | 1 | |
| 36.49944234 | 1 | |
| 35.69618895 | 1 | |
| 32.61878034 | 1 |
Avg_no_of_Items
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4410231 |
| Minimum | 2.0756615 |
|---|---|
| Maximum | 2.6644212 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 2.0756615 |
|---|---|
| 5-th percentile | 2.3086745 |
| Q1 | 2.3784401 |
| median | 2.4394097 |
| Q3 | 2.4988163 |
| 95-th percentile | 2.6147799 |
| Maximum | 2.6644212 |
| Range | 0.5887597 |
| Interquartile range (IQR) | 0.12037623 |
Descriptive statistics
| Standard deviation | 0.10777045 |
|---|---|
| Coefficient of variation (CV) | 0.044149705 |
| Kurtosis | 2.623501 |
| Mean | 2.4410231 |
| Median Absolute Deviation (MAD) | 0.060937754 |
| Skewness | -0.65526161 |
| Sum | 95.199901 |
| Variance | 0.01161447 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.611781593 | 1 | 0.1% |
| 2.439409675 | 1 | 0.1% |
| 2.394601672 | 1 | 0.1% |
| 2.355238236 | 1 | 0.1% |
| 2.441304552 | 1 | 0.1% |
| 2.373127402 | 1 | 0.1% |
| 2.380412964 | 1 | 0.1% |
| 2.376467139 | 1 | 0.1% |
| 2.500347429 | 1 | 0.1% |
| 2.367340494 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 2.075661489 | 1 | |
| 2.247411257 | 1 | |
| 2.315481574 | 1 | |
| 2.338756906 | 1 | |
| 2.355238236 | 1 | |
| 2.356779358 | 1 | |
| 2.367340494 | 1 | |
| 2.370742719 | 1 | |
| 2.373127402 | 1 | |
| 2.376467139 | 1 |
| Value | Count | Frequency (%) |
| 2.664421184 | 1 | |
| 2.641764423 | 1 | |
| 2.611781593 | 1 | |
| 2.579820963 | 1 | |
| 2.56394635 | 1 | |
| 2.55980947 | 1 | |
| 2.522813601 | 1 | |
| 2.520409444 | 1 | |
| 2.509644942 | 1 | |
| 2.500347429 | 1 |
pct_PromoMarketDollars_Category
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 37 |
|---|---|
| Distinct (%) | 94.9% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.023944513 |
| Minimum | 0.000238 |
|---|---|
| Maximum | 0.0701 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.000238 |
|---|---|
| 5-th percentile | 0.0012128 |
| Q1 | 0.00663 |
| median | 0.0228 |
| Q3 | 0.03355 |
| 95-th percentile | 0.06126 |
| Maximum | 0.0701 |
| Range | 0.069862 |
| Interquartile range (IQR) | 0.02692 |
Descriptive statistics
| Standard deviation | 0.019448843 |
|---|---|
| Coefficient of variation (CV) | 0.81224634 |
| Kurtosis | -0.12535319 |
| Mean | 0.023944513 |
| Median Absolute Deviation (MAD) | 0.0151 |
| Skewness | 0.7091727 |
| Sum | 0.933836 |
| Variance | 0.00037825749 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.00131 | 2 | 0.2% |
| 0.0391 | 2 | 0.2% |
| 0.0339 | 1 | 0.1% |
| 0.0332 | 1 | 0.1% |
| 0.000238 | 1 | 0.1% |
| 0.069 | 1 | 0.1% |
| 0.0701 | 1 | 0.1% |
| 0.0116 | 1 | 0.1% |
| 0.0282 | 1 | 0.1% |
| 0.00167 | 1 | 0.1% |
| Other values (27) | 27 | 2.7% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.000238 | 1 | |
| 0.000338 | 1 | |
| 0.00131 | 2 | |
| 0.00167 | 1 | |
| 0.00208 | 1 | |
| 0.00218 | 1 | |
| 0.0046 | 1 | |
| 0.00508 | 1 | |
| 0.00561 | 1 | |
| 0.00765 | 1 |
| Value | Count | Frequency (%) |
| 0.0701 | 1 | |
| 0.069 | 1 | |
| 0.0604 | 1 | |
| 0.0546 | 1 | |
| 0.0498 | 1 | |
| 0.0435 | 1 | |
| 0.0391 | 2 | |
| 0.0379 | 1 | |
| 0.0339 | 1 | |
| 0.0332 | 1 |
RPI_Category
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.444523 |
| Minimum | 32.483718 |
|---|---|
| Maximum | 44.150672 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 32.483718 |
|---|---|
| 5-th percentile | 34.943844 |
| Q1 | 36.515377 |
| median | 38.322539 |
| Q3 | 39.624823 |
| 95-th percentile | 43.816508 |
| Maximum | 44.150672 |
| Range | 11.666954 |
| Interquartile range (IQR) | 3.1094468 |
Descriptive statistics
| Standard deviation | 2.6866858 |
|---|---|
| Coefficient of variation (CV) | 0.069884747 |
| Kurtosis | 0.21819677 |
| Mean | 38.444523 |
| Median Absolute Deviation (MAD) | 1.4221715 |
| Skewness | 0.30175038 |
| Sum | 1499.3364 |
| Variance | 7.2182804 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 35.8170301 | 1 | 0.1% |
| 35.60193658 | 1 | 0.1% |
| 43.46628595 | 1 | 0.1% |
| 43.82917152 | 1 | 0.1% |
| 39.45845883 | 1 | 0.1% |
| 32.48371839 | 1 | 0.1% |
| 37.44135801 | 1 | 0.1% |
| 36.33485966 | 1 | 0.1% |
| 33.87605773 | 1 | 0.1% |
| 39.79367136 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 32.48371839 | 1 | |
| 33.87605773 | 1 | |
| 35.06248741 | 1 | |
| 35.15751934 | 1 | |
| 35.1600389 | 1 | |
| 35.60193658 | 1 | |
| 35.8170301 | 1 | |
| 36.33485966 | 1 | |
| 36.38906504 | 1 | |
| 36.43076918 | 1 |
| Value | Count | Frequency (%) |
| 44.15067215 | 1 | |
| 43.82917152 | 1 | |
| 43.81510046 | 1 | |
| 43.46628595 | 1 | |
| 42.15348153 | 1 | |
| 41.02094103 | 1 | |
| 39.93345167 | 1 | |
| 39.79367136 | 1 | |
| 39.74471047 | 1 | |
| 39.65389732 | 1 |
Magazine_Impressions_pct
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 13 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 991 |
| Missing (%) | 98.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 45.554208 |
| Minimum | 7.0809506 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 7.0809506 |
|---|---|
| 5-th percentile | 21.456293 |
| Q1 | 32.195566 |
| median | 40.158646 |
| Q3 | 54.359634 |
| 95-th percentile | 83.56614 |
| Maximum | 100 |
| Range | 92.919049 |
| Interquartile range (IQR) | 22.164069 |
Descriptive statistics
| Standard deviation | 22.528613 |
|---|---|
| Coefficient of variation (CV) | 0.49454516 |
| Kurtosis | 2.3083157 |
| Mean | 45.554208 |
| Median Absolute Deviation (MAD) | 8.5479674 |
| Skewness | 1.0079193 |
| Sum | 592.2047 |
| Variance | 507.5384 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 31.70243263 | 1 | 0.1% |
| 40.15864586 | 1 | 0.1% |
| 31.03985479 | 1 | 0.1% |
| 32.19556553 | 1 | 0.1% |
| 38.00281558 | 1 | 0.1% |
| 41.14668609 | 1 | 0.1% |
| 55.70909421 | 1 | 0.1% |
| 100 | 1 | 0.1% |
| 7.080950566 | 1 | 0.1% |
| 48.7066133 | 1 | 0.1% |
| Other values (3) | 3 | 0.3% |
| (Missing) | 991 |
| Value | Count | Frequency (%) |
| 7.080950566 | 1 | |
| 31.03985479 | 1 | |
| 31.70243263 | 1 | |
| 32.19556553 | 1 | |
| 38.00281558 | 1 | |
| 39.49217447 | 1 | |
| 40.15864586 | 1 | |
| 41.14668609 | 1 | |
| 48.7066133 | 1 | |
| 54.35963436 | 1 |
| Value | Count | Frequency (%) |
| 100 | 1 | |
| 72.61023408 | 1 | |
| 55.70909421 | 1 | |
| 54.35963436 | 1 | |
| 48.7066133 | 1 | |
| 41.14668609 | 1 | |
| 40.15864586 | 1 | |
| 39.49217447 | 1 | |
| 38.00281558 | 1 | |
| 32.19556553 | 1 |
TV_GRP
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 12 |
|---|---|
| Distinct (%) | 92.3% |
| Missing | 991 |
| Missing (%) | 98.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 32.015385 |
| Minimum | 2.2 |
|---|---|
| Maximum | 54.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 2.2 |
|---|---|
| 5-th percentile | 2.86 |
| Q1 | 25.3 |
| median | 34.1 |
| Q3 | 44.7 |
| 95-th percentile | 50.46 |
| Maximum | 54.6 |
| Range | 52.4 |
| Interquartile range (IQR) | 19.4 |
Descriptive statistics
| Standard deviation | 16.372581 |
|---|---|
| Coefficient of variation (CV) | 0.51139729 |
| Kurtosis | -0.24904447 |
| Mean | 32.015385 |
| Median Absolute Deviation (MAD) | 10.6 |
| Skewness | -0.74934286 |
| Sum | 416.2 |
| Variance | 268.06141 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44.7 | 2 | 0.2% |
| 25.3 | 1 | 0.1% |
| 47.7 | 1 | 0.1% |
| 32 | 1 | 0.1% |
| 16.5 | 1 | 0.1% |
| 34.1 | 1 | 0.1% |
| 54.6 | 1 | 0.1% |
| 3.3 | 1 | 0.1% |
| 2.2 | 1 | 0.1% |
| 36.1 | 1 | 0.1% |
| Other values (2) | 2 | 0.2% |
| (Missing) | 991 |
| Value | Count | Frequency (%) |
| 2.2 | 1 | |
| 3.3 | 1 | |
| 16.5 | 1 | |
| 25.3 | 1 | |
| 32 | 1 | |
| 32.1 | 1 | |
| 34.1 | 1 | |
| 36.1 | 1 | |
| 42.9 | 1 | |
| 44.7 | 2 |
| Value | Count | Frequency (%) |
| 54.6 | 1 | |
| 47.7 | 1 | |
| 44.7 | 2 | |
| 42.9 | 1 | |
| 36.1 | 1 | |
| 34.1 | 1 | |
| 32.1 | 1 | |
| 32 | 1 | |
| 25.3 | 1 | |
| 16.5 | 1 |
Competitor1_RPI
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.20077 |
| Minimum | 83.88348 |
|---|---|
| Maximum | 121.88965 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 83.88348 |
|---|---|
| 5-th percentile | 89.42131 |
| Q1 | 97.092027 |
| median | 100.73498 |
| Q3 | 106.34821 |
| 95-th percentile | 119.48732 |
| Maximum | 121.88965 |
| Range | 38.006167 |
| Interquartile range (IQR) | 9.2561836 |
Descriptive statistics
| Standard deviation | 8.7884917 |
|---|---|
| Coefficient of variation (CV) | 0.085992418 |
| Kurtosis | 0.30812943 |
| Mean | 102.20077 |
| Median Absolute Deviation (MAD) | 4.3372389 |
| Skewness | 0.4863789 |
| Sum | 3985.8302 |
| Variance | 77.237586 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 97.17336466 | 1 | 0.1% |
| 87.36488373 | 1 | 0.1% |
| 121.7807344 | 1 | 0.1% |
| 121.8896469 | 1 | 0.1% |
| 110.9249541 | 1 | 0.1% |
| 89.64980128 | 1 | 0.1% |
| 100.6896746 | 1 | 0.1% |
| 97.0106887 | 1 | 0.1% |
| 83.88348026 | 1 | 0.1% |
| 100.8296163 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 83.88348026 | 1 | |
| 87.36488373 | 1 | |
| 89.64980128 | 1 | |
| 90.38899785 | 1 | |
| 94.34874349 | 1 | |
| 94.34950641 | 1 | |
| 94.65400559 | 1 | |
| 96.23896326 | 1 | |
| 96.39773904 | 1 | |
| 97.0106887 | 1 |
| Value | Count | Frequency (%) |
| 121.8896469 | 1 | |
| 121.7807344 | 1 | |
| 119.2324944 | 1 | |
| 116.0987152 | 1 | |
| 115.7900253 | 1 | |
| 111.4366591 | 1 | |
| 110.9249541 | 1 | |
| 107.7055227 | 1 | |
| 107.501689 | 1 | |
| 107.289052 | 1 |
Competitor2_RPI
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 38.646238 |
| Minimum | 32.368993 |
|---|---|
| Maximum | 57.797794 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 32.368993 |
|---|---|
| 5-th percentile | 33.647452 |
| Q1 | 35.718011 |
| median | 37.377758 |
| Q3 | 40.034473 |
| 95-th percentile | 47.549814 |
| Maximum | 57.797794 |
| Range | 25.428801 |
| Interquartile range (IQR) | 4.3164622 |
Descriptive statistics
| Standard deviation | 4.9336107 |
|---|---|
| Coefficient of variation (CV) | 0.12766083 |
| Kurtosis | 5.2954731 |
| Mean | 38.646238 |
| Median Absolute Deviation (MAD) | 2.0234267 |
| Skewness | 2.0058075 |
| Sum | 1507.2033 |
| Variance | 24.340515 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 35.5573706 | 1 | 0.1% |
| 34.23075395 | 1 | 0.1% |
| 47.32223879 | 1 | 0.1% |
| 57.79779387 | 1 | 0.1% |
| 42.06462378 | 1 | 0.1% |
| 33.66406503 | 1 | 0.1% |
| 37.94362683 | 1 | 0.1% |
| 36.12551332 | 1 | 0.1% |
| 32.36899323 | 1 | 0.1% |
| 39.40118477 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 32.36899323 | 1 | |
| 33.49793635 | 1 | |
| 33.66406503 | 1 | |
| 34.01330448 | 1 | |
| 34.10690902 | 1 | |
| 34.23075395 | 1 | |
| 35.3278177 | 1 | |
| 35.38346566 | 1 | |
| 35.5573706 | 1 | |
| 35.66301282 | 1 |
| Value | Count | Frequency (%) |
| 57.79779387 | 1 | |
| 49.59798765 | 1 | |
| 47.32223879 | 1 | |
| 46.59875087 | 1 | |
| 43.79453493 | 1 | |
| 42.06462378 | 1 | |
| 40.99914055 | 1 | |
| 40.80056283 | 1 | |
| 40.77367979 | 1 | |
| 40.11524723 | 1 |
Competitor3_RPI
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.691582 |
| Minimum | 38.550768 |
|---|---|
| Maximum | 53.14956 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 38.550768 |
|---|---|
| 5-th percentile | 41.039663 |
| Q1 | 41.881951 |
| median | 44.631443 |
| Q3 | 45.924004 |
| 95-th percentile | 50.642978 |
| Maximum | 53.14956 |
| Range | 14.598792 |
| Interquartile range (IQR) | 4.0420538 |
Descriptive statistics
| Standard deviation | 3.2616204 |
|---|---|
| Coefficient of variation (CV) | 0.072980642 |
| Kurtosis | 0.091798865 |
| Mean | 44.691582 |
| Median Absolute Deviation (MAD) | 2.3529062 |
| Skewness | 0.64060135 |
| Sum | 1742.9717 |
| Variance | 10.638167 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44.5027166 | 1 | 0.1% |
| 41.67147334 | 1 | 0.1% |
| 48.11000271 | 1 | 0.1% |
| 50.75372632 | 1 | 0.1% |
| 50.63067266 | 1 | 0.1% |
| 41.94094798 | 1 | 0.1% |
| 47.56254104 | 1 | 0.1% |
| 44.80722005 | 1 | 0.1% |
| 38.55076817 | 1 | 0.1% |
| 45.60053185 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 38.55076817 | 1 | |
| 40.57701559 | 1 | |
| 41.0910685 | 1 | |
| 41.09825991 | 1 | |
| 41.11727898 | 1 | |
| 41.35673961 | 1 | |
| 41.5784288 | 1 | |
| 41.67147334 | 1 | |
| 41.82217926 | 1 | |
| 41.82295335 | 1 |
| Value | Count | Frequency (%) |
| 53.14956001 | 1 | |
| 50.75372632 | 1 | |
| 50.63067266 | 1 | |
| 50.25328013 | 1 | |
| 49.15358948 | 1 | |
| 48.51507 | 1 | |
| 48.11000271 | 1 | |
| 47.56254104 | 1 | |
| 46.9843496 | 1 | |
| 46.05511752 | 1 |
Competitor4_RPI
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 65.408013 |
| Minimum | 57.583497 |
|---|---|
| Maximum | 76.896817 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 57.583497 |
|---|---|
| 5-th percentile | 58.244896 |
| Q1 | 62.430457 |
| median | 65.324834 |
| Q3 | 67.668061 |
| 95-th percentile | 73.933601 |
| Maximum | 76.896817 |
| Range | 19.313319 |
| Interquartile range (IQR) | 5.2376033 |
Descriptive statistics
| Standard deviation | 4.7680283 |
|---|---|
| Coefficient of variation (CV) | 0.072896699 |
| Kurtosis | 0.058150571 |
| Mean | 65.408013 |
| Median Absolute Deviation (MAD) | 2.5930926 |
| Skewness | 0.48967535 |
| Sum | 2550.9125 |
| Variance | 22.734093 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63.37726834 | 1 | 0.1% |
| 60.73202313 | 1 | 0.1% |
| 73.75335702 | 1 | 0.1% |
| 72.36783163 | 1 | 0.1% |
| 66.77421557 | 1 | 0.1% |
| 57.58349716 | 1 | 0.1% |
| 63.89726566 | 1 | 0.1% |
| 59.01686676 | 1 | 0.1% |
| 57.73976417 | 1 | 0.1% |
| 69.42991188 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 57.58349716 | 1 | |
| 57.73976417 | 1 | |
| 58.30102122 | 1 | |
| 58.65609009 | 1 | |
| 59.01686676 | 1 | |
| 59.83749185 | 1 | |
| 60.73202313 | 1 | |
| 61.96259384 | 1 | |
| 62.09041692 | 1 | |
| 62.12917301 | 1 |
| Value | Count | Frequency (%) |
| 76.89681663 | 1 | |
| 75.55580103 | 1 | |
| 73.75335702 | 1 | |
| 73.35213669 | 1 | |
| 72.36783163 | 1 | |
| 69.65789115 | 1 | |
| 69.42991188 | 1 | |
| 68.54778981 | 1 | |
| 68.41594326 | 1 | |
| 67.80109055 | 1 |
EQ_Category
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2111044.5 |
| Minimum | 1504338.6 |
|---|---|
| Maximum | 2867306.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 1504338.6 |
|---|---|
| 5-th percentile | 1605847 |
| Q1 | 1774046.4 |
| median | 2010362 |
| Q3 | 2422063.9 |
| 95-th percentile | 2798604.2 |
| Maximum | 2867306.9 |
| Range | 1362968.3 |
| Interquartile range (IQR) | 648017.44 |
Descriptive statistics
| Standard deviation | 409968.15 |
|---|---|
| Coefficient of variation (CV) | 0.19420157 |
| Kurtosis | -1.0549072 |
| Mean | 2111044.5 |
| Median Absolute Deviation (MAD) | 314268.41 |
| Skewness | 0.42773953 |
| Sum | 82330735 |
| Variance | 1.6807388 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1728388.673 | 1 | 0.1% |
| 2494566.851 | 1 | 0.1% |
| 1666900.398 | 1 | 0.1% |
| 1610351.525 | 1 | 0.1% |
| 1791357.204 | 1 | 0.1% |
| 1919431.786 | 1 | 0.1% |
| 2010362.037 | 1 | 0.1% |
| 2242374.168 | 1 | 0.1% |
| 2747208.438 | 1 | 0.1% |
| 2229095.053 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 1504338.62 | 1 | |
| 1565306.078 | 1 | |
| 1610351.525 | 1 | |
| 1628453.07 | 1 | |
| 1628818.628 | 1 | |
| 1645094.597 | 1 | |
| 1666900.398 | 1 | |
| 1696093.627 | 1 | |
| 1728388.673 | 1 | |
| 1756735.667 | 1 |
| Value | Count | Frequency (%) |
| 2867306.933 | 1 | |
| 2813494.081 | 1 | |
| 2796949.72 | 1 | |
| 2747208.438 | 1 | |
| 2727062.938 | 1 | |
| 2715526.999 | 1 | |
| 2674460.512 | 1 | |
| 2606894.637 | 1 | |
| 2494566.851 | 1 | |
| 2441916.655 | 1 |
EQ_Subcategory
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 494376.64 |
| Minimum | 249237.49 |
|---|---|
| Maximum | 856242.94 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 249237.49 |
|---|---|
| 5-th percentile | 268333.3 |
| Q1 | 333269.46 |
| median | 421134.37 |
| Q3 | 637651.87 |
| 95-th percentile | 819717.48 |
| Maximum | 856242.94 |
| Range | 607005.45 |
| Interquartile range (IQR) | 304382.41 |
Descriptive statistics
| Standard deviation | 198096.7 |
|---|---|
| Coefficient of variation (CV) | 0.40069996 |
| Kurtosis | -1.1628781 |
| Mean | 494376.64 |
| Median Absolute Deviation (MAD) | 138203.97 |
| Skewness | 0.56846732 |
| Sum | 19280689 |
| Variance | 3.9242301 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 331927.5394 | 1 | 0.1% |
| 718652.2126 | 1 | 0.1% |
| 282930.3995 | 1 | 0.1% |
| 258255.9299 | 1 | 0.1% |
| 340550.0339 | 1 | 0.1% |
| 384255.6322 | 1 | 0.1% |
| 468177.8792 | 1 | 0.1% |
| 607623.5341 | 1 | 0.1% |
| 856242.9394 | 1 | 0.1% |
| 577838.0553 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 249237.4935 | 1 | |
| 258255.9299 | 1 | |
| 269453.0058 | 1 | |
| 272019.8263 | 1 | |
| 282930.3995 | 1 | |
| 297210.5135 | 1 | |
| 312550.9088 | 1 | |
| 320624.477 | 1 | |
| 329510.9938 | 1 | |
| 331927.5394 | 1 |
| Value | Count | Frequency (%) |
| 856242.9394 | 1 | |
| 828776.1488 | 1 | |
| 818710.965 | 1 | |
| 806075.7642 | 1 | |
| 799657.5538 | 1 | |
| 798281.1536 | 1 | |
| 789109.5698 | 1 | |
| 746305.3712 | 1 | |
| 718652.2126 | 1 | |
| 645477.096 | 1 |
pct_PromoMarketDollars_Subcategory
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.10877174 |
| Minimum | 0.001658878 |
|---|---|
| Maximum | 0.4300507 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 0.001658878 |
|---|---|
| 5-th percentile | 0.005254957 |
| Q1 | 0.02759147 |
| median | 0.078074178 |
| Q3 | 0.14328179 |
| 95-th percentile | 0.3343356 |
| Maximum | 0.4300507 |
| Range | 0.42839183 |
| Interquartile range (IQR) | 0.11569032 |
Descriptive statistics
| Standard deviation | 0.10991898 |
|---|---|
| Coefficient of variation (CV) | 1.0105472 |
| Kurtosis | 1.540769 |
| Mean | 0.10877174 |
| Median Absolute Deviation (MAD) | 0.053323631 |
| Skewness | 1.4556426 |
| Sum | 4.2420979 |
| Variance | 0.012082183 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0.162731521 | 1 | 0.1% |
| 0.058437503 | 1 | 0.1% |
| 0.001658878 | 1 | 0.1% |
| 0.011638628 | 1 | 0.1% |
| 0.430050703 | 1 | 0.1% |
| 0.328796979 | 1 | 0.1% |
| 0.047280441 | 1 | 0.1% |
| 0.079705177 | 1 | 0.1% |
| 0.087384017 | 1 | 0.1% |
| 0.005624782 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 0.001658878 | 1 | |
| 0.001926532 | 1 | |
| 0.005624782 | 1 | |
| 0.006404826 | 1 | |
| 0.009903904 | 1 | |
| 0.011440443 | 1 | |
| 0.011638628 | 1 | |
| 0.021788474 | 1 | |
| 0.024750547 | 1 | |
| 0.025270511 | 1 |
| Value | Count | Frequency (%) |
| 0.430050703 | 1 | |
| 0.384183216 | 1 | |
| 0.328796979 | 1 | |
| 0.313571471 | 1 | |
| 0.277988387 | 1 | |
| 0.231649656 | 1 | |
| 0.197980453 | 1 | |
| 0.164553649 | 1 | |
| 0.162731521 | 1 | |
| 0.147320401 | 1 |
RPI_Subcategory
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 39 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 965 |
| Missing (%) | 96.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 42.356404 |
| Minimum | 35.480731 |
|---|---|
| Maximum | 49.735737 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 8.0 KiB |
Quantile statistics
| Minimum | 35.480731 |
|---|---|
| 5-th percentile | 37.303882 |
| Q1 | 40.485839 |
| median | 42.776921 |
| Q3 | 44.000818 |
| 95-th percentile | 47.25904 |
| Maximum | 49.735737 |
| Range | 14.255006 |
| Interquartile range (IQR) | 3.514979 |
Descriptive statistics
| Standard deviation | 3.0601739 |
|---|---|
| Coefficient of variation (CV) | 0.072248199 |
| Kurtosis | 0.10309477 |
| Mean | 42.356404 |
| Median Absolute Deviation (MAD) | 1.9801517 |
| Skewness | 0.011579542 |
| Sum | 1651.8998 |
| Variance | 9.3646643 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40.5605634 | 1 | 0.1% |
| 39.03629435 | 1 | 0.1% |
| 47.22971507 | 1 | 0.1% |
| 46.75195932 | 1 | 0.1% |
| 42.90814972 | 1 | 0.1% |
| 35.48073086 | 1 | 0.1% |
| 40.79676921 | 1 | 0.1% |
| 39.62948816 | 1 | 0.1% |
| 37.30460734 | 1 | 0.1% |
| 43.41399501 | 1 | 0.1% |
| Other values (29) | 29 | 2.9% |
| (Missing) | 965 |
| Value | Count | Frequency (%) |
| 35.48073086 | 1 | |
| 37.29735544 | 1 | |
| 37.30460734 | 1 | |
| 37.55477636 | 1 | |
| 38.51760805 | 1 | |
| 39.03629435 | 1 | |
| 39.62948816 | 1 | |
| 40.04630072 | 1 | |
| 40.3389159 | 1 | |
| 40.41111476 | 1 |
| Value | Count | Frequency (%) |
| 49.73573734 | 1 | |
| 47.52295983 | 1 | |
| 47.22971507 | 1 | |
| 46.75195932 | 1 | |
| 46.15429647 | 1 | |
| 45.07282152 | 1 | |
| 45.04213455 | 1 | |
| 44.54279611 | 1 | |
| 44.20156633 | 1 | |
| 44.07567409 | 1 |
| EQ | Social_Search_Impressions | Social_Search_Working_cost | Digital_Impressions | Digital_Working_cost | Print_Impressions.Ads40 | Print_Working_Cost.Ads50 | OOH_Impressions | OOH_Working_Cost | SOS_pct | Digital_Impressions_pct | CCFOT | Median_Temp | Median_Rainfall | Fuel_Price | Inflation | Trade_Invest | Brand_Equity | Avg_EQ_Price | Any_Promo_pct_ACV | Any_Feat_pct_ACV | Any_Disp_pct_ACV | EQ_Base_Price | Est_ACV_Selling | pct_ACV | Avg_no_of_Items | pct_PromoMarketDollars_Category | RPI_Category | Magazine_Impressions_pct | TV_GRP | Competitor1_RPI | Competitor2_RPI | Competitor3_RPI | Competitor4_RPI | EQ_Category | EQ_Subcategory | pct_PromoMarketDollars_Subcategory | RPI_Subcategory | Period | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EQ | 1.000 | 0.183 | 0.075 | -0.448 | -0.705 | -0.553 | -0.487 | -0.252 | -0.150 | -0.154 | -0.615 | 0.173 | 0.132 | 0.301 | -0.785 | -0.631 | 0.412 | 0.351 | -0.395 | 0.496 | -0.832 | 0.160 | -0.241 | 0.863 | 0.867 | 0.767 | 0.446 | -0.058 | -0.489 | -0.143 | -0.198 | -0.442 | -0.376 | -0.141 | 0.545 | 0.439 | 0.328 | 0.068 | 1.000 |
| Social_Search_Impressions | 0.183 | 1.000 | 0.930 | 0.363 | 0.182 | 0.358 | 0.382 | 0.098 | 0.383 | 0.200 | -0.434 | 0.047 | 0.700 | 0.154 | 0.115 | -0.055 | -0.105 | -0.078 | 0.014 | 0.070 | -0.250 | 0.325 | 0.053 | -0.089 | -0.067 | 0.389 | -0.082 | 0.260 | 0.095 | 0.452 | 0.082 | -0.195 | 0.059 | 0.216 | 0.687 | 0.642 | -0.208 | 0.314 | 1.000 |
| Social_Search_Working_cost | 0.075 | 0.930 | 1.000 | 0.490 | 0.291 | 0.430 | 0.424 | 0.210 | 0.133 | 0.288 | -0.258 | 0.046 | 0.737 | 0.124 | 0.109 | -0.124 | -0.110 | -0.091 | 0.045 | -0.104 | -0.183 | 0.371 | 0.039 | -0.163 | -0.118 | 0.315 | -0.205 | 0.303 | 0.524 | 0.738 | 0.074 | -0.109 | 0.099 | 0.296 | 0.579 | 0.567 | -0.328 | 0.359 | 1.000 |
| Digital_Impressions | -0.448 | 0.363 | 0.490 | 1.000 | 0.881 | 0.572 | 0.585 | 0.155 | -0.238 | 0.151 | 0.248 | 0.188 | 0.295 | 0.272 | 0.377 | 0.384 | -0.679 | 0.028 | 0.277 | -0.303 | 0.571 | -0.110 | 0.374 | -0.480 | -0.489 | -0.381 | -0.171 | 0.335 | 0.505 | 0.223 | 0.301 | 0.135 | 0.230 | 0.264 | 0.164 | 0.270 | -0.295 | 0.318 | 1.000 |
| Digital_Working_cost | -0.705 | 0.182 | 0.291 | 0.881 | 1.000 | 0.722 | 0.733 | 0.285 | -0.286 | 0.165 | 0.267 | 0.234 | 0.237 | 0.255 | 0.605 | 0.652 | -0.793 | -0.071 | 0.373 | -0.446 | 0.571 | -0.223 | 0.571 | -0.739 | -0.755 | -0.391 | -0.248 | 0.273 | 0.615 | 0.116 | 0.346 | 0.197 | 0.307 | 0.274 | -0.017 | 0.132 | -0.385 | 0.250 | 1.000 |
| Print_Impressions.Ads40 | -0.553 | 0.358 | 0.430 | 0.572 | 0.722 | 1.000 | 0.987 | 0.755 | 0.317 | 0.163 | -0.500 | -0.156 | 0.250 | 0.288 | 0.656 | 0.517 | -0.633 | -0.280 | 0.173 | -0.261 | 0.294 | 0.044 | 0.366 | -0.746 | -0.744 | -0.375 | -0.034 | 0.037 | 0.659 | 0.239 | 0.109 | 0.007 | 0.174 | 0.107 | -0.008 | 0.119 | -0.111 | 0.019 | 1.000 |
| Print_Working_Cost.Ads50 | -0.487 | 0.382 | 0.424 | 0.585 | 0.733 | 0.987 | 1.000 | 0.189 | -0.183 | 0.141 | -0.665 | -0.120 | 0.241 | 0.280 | 0.601 | 0.468 | -0.662 | -0.232 | 0.204 | -0.242 | 0.287 | 0.052 | 0.453 | -0.685 | -0.683 | -0.324 | 0.011 | 0.084 | 0.604 | 0.094 | 0.173 | -0.001 | 0.196 | 0.141 | 0.024 | 0.146 | -0.082 | 0.086 | 1.000 |
| OOH_Impressions | -0.252 | 0.098 | 0.210 | 0.155 | 0.285 | 0.755 | 0.189 | 1.000 | 0.917 | -0.014 | 0.383 | 0.094 | 0.476 | 0.643 | 0.566 | 0.608 | 0.343 | -0.306 | -0.175 | 0.000 | -0.600 | -0.430 | -0.650 | -0.392 | -0.476 | -0.077 | -0.427 | -0.399 | 0.190 | 0.619 | -0.580 | -0.056 | -0.182 | -0.189 | 0.140 | 0.217 | -0.587 | -0.490 | 1.000 |
| OOH_Working_Cost | -0.150 | 0.383 | 0.133 | -0.238 | -0.286 | 0.317 | -0.183 | 0.917 | 1.000 | -0.383 | 0.071 | 0.102 | 0.633 | 0.283 | 0.750 | 0.917 | 0.367 | -0.203 | -0.283 | -0.083 | 0.400 | -0.429 | -0.600 | -0.150 | -0.283 | -0.117 | -0.300 | -0.367 | 0.143 | 0.086 | -0.600 | -0.200 | -0.367 | -0.233 | 0.133 | 0.167 | -0.450 | -0.467 | 1.000 |
| SOS_pct | -0.154 | 0.200 | 0.288 | 0.151 | 0.165 | 0.163 | 0.141 | -0.014 | -0.383 | 1.000 | -0.088 | -0.206 | 0.128 | 0.033 | 0.089 | -0.244 | 0.065 | -0.046 | 0.120 | 0.010 | -0.210 | -0.019 | 0.092 | -0.164 | -0.137 | 0.080 | -0.131 | 0.221 | 0.038 | 0.267 | 0.138 | 0.210 | 0.117 | 0.093 | -0.047 | -0.038 | -0.118 | 0.240 | 1.000 |
| Digital_Impressions_pct | -0.615 | -0.434 | -0.258 | 0.248 | 0.267 | -0.500 | -0.665 | 0.383 | 0.071 | -0.088 | 1.000 | -0.098 | -0.192 | -0.247 | 0.335 | 0.286 | 0.291 | -0.539 | -0.110 | 0.148 | 0.400 | 0.154 | -0.489 | -0.522 | -0.467 | -0.192 | 0.016 | -0.434 | 0.771 | 0.657 | -0.324 | 0.297 | -0.027 | -0.187 | -0.412 | -0.368 | 0.297 | -0.495 | 1.000 |
| CCFOT | 0.173 | 0.047 | 0.046 | 0.188 | 0.234 | -0.156 | -0.120 | 0.094 | 0.102 | -0.206 | -0.098 | 1.000 | 0.024 | 0.007 | -0.347 | -0.037 | -0.015 | 0.449 | 0.146 | -0.178 | -0.015 | -0.154 | 0.276 | 0.300 | 0.281 | 0.303 | -0.126 | 0.242 | 0.283 | -0.179 | 0.217 | -0.042 | -0.058 | 0.255 | 0.028 | -0.011 | -0.204 | 0.266 | 1.000 |
| Median_Temp | 0.132 | 0.700 | 0.737 | 0.295 | 0.237 | 0.250 | 0.241 | 0.476 | 0.633 | 0.128 | -0.192 | 0.024 | 1.000 | 0.487 | 0.101 | -0.059 | 0.009 | 0.087 | -0.178 | 0.013 | -0.434 | 0.432 | -0.104 | -0.087 | -0.042 | 0.169 | -0.167 | 0.162 | 0.294 | 0.092 | -0.170 | -0.236 | -0.240 | 0.079 | 0.793 | 0.798 | -0.387 | 0.240 | 1.000 |
| Median_Rainfall | 0.301 | 0.154 | 0.124 | 0.272 | 0.255 | 0.288 | 0.280 | 0.643 | 0.283 | 0.033 | -0.247 | 0.007 | 0.487 | 1.000 | 0.053 | 0.050 | -0.043 | -0.014 | -0.413 | 0.283 | -0.566 | 0.235 | -0.173 | 0.007 | 0.011 | 0.259 | 0.224 | -0.237 | 0.560 | 0.319 | -0.362 | -0.370 | -0.415 | -0.267 | 0.571 | 0.592 | 0.015 | -0.147 | 1.000 |
| Fuel_Price | -0.785 | 0.115 | 0.109 | 0.377 | 0.605 | 0.656 | 0.601 | 0.566 | 0.750 | 0.089 | 0.335 | -0.347 | 0.101 | 0.053 | 1.000 | 0.758 | -0.518 | -0.530 | 0.055 | -0.104 | 0.769 | 0.012 | 0.094 | -0.921 | -0.905 | -0.560 | -0.115 | -0.219 | 0.363 | 0.201 | -0.127 | 0.048 | 0.140 | -0.130 | -0.141 | -0.001 | -0.135 | -0.273 | 1.000 |
| Inflation | -0.631 | -0.055 | -0.124 | 0.384 | 0.652 | 0.517 | 0.468 | 0.608 | 0.917 | -0.244 | 0.286 | -0.037 | -0.059 | 0.050 | 0.758 | 1.000 | -0.605 | -0.213 | 0.060 | -0.029 | 0.734 | -0.073 | 0.181 | -0.734 | -0.728 | -0.393 | 0.093 | -0.288 | 0.516 | -0.063 | -0.090 | -0.076 | 0.047 | -0.131 | -0.229 | -0.127 | 0.072 | -0.362 | 1.000 |
| Trade_Invest | 0.412 | -0.105 | -0.110 | -0.679 | -0.793 | -0.633 | -0.662 | 0.343 | 0.367 | 0.065 | 0.291 | -0.015 | 0.009 | -0.043 | -0.518 | -0.605 | 1.000 | 0.070 | -0.282 | 0.153 | -0.385 | 0.067 | -0.527 | 0.537 | 0.527 | 0.215 | -0.119 | -0.081 | -0.522 | 0.069 | -0.220 | -0.057 | -0.273 | -0.137 | 0.068 | -0.023 | -0.071 | -0.057 | 1.000 |
| Brand_Equity | 0.351 | -0.078 | -0.091 | 0.028 | -0.071 | -0.280 | -0.232 | -0.306 | -0.203 | -0.046 | -0.539 | 0.449 | 0.087 | -0.014 | -0.530 | -0.213 | 0.070 | 1.000 | 0.357 | -0.034 | -0.663 | -0.375 | 0.385 | 0.526 | 0.548 | 0.257 | -0.095 | 0.512 | -0.562 | -0.165 | 0.456 | 0.000 | -0.029 | 0.437 | 0.158 | 0.061 | -0.133 | 0.541 | 1.000 |
| Avg_EQ_Price | -0.395 | 0.014 | 0.045 | 0.277 | 0.373 | 0.173 | 0.204 | -0.175 | -0.283 | 0.120 | -0.110 | 0.146 | -0.178 | -0.413 | 0.055 | 0.060 | -0.282 | 0.357 | 1.000 | -0.588 | -0.021 | -0.599 | 0.757 | -0.101 | -0.067 | -0.315 | -0.520 | 0.847 | 0.115 | -0.110 | 0.943 | 0.713 | 0.819 | 0.882 | -0.374 | -0.347 | -0.465 | 0.758 | 1.000 |
| Any_Promo_pct_ACV | 0.496 | 0.070 | -0.104 | -0.303 | -0.446 | -0.261 | -0.242 | 0.000 | -0.083 | 0.010 | 0.148 | -0.178 | 0.013 | 0.283 | -0.104 | -0.029 | 0.153 | -0.034 | -0.588 | 1.000 | -0.503 | 0.333 | -0.360 | 0.228 | 0.243 | 0.451 | 0.713 | -0.478 | -0.341 | 0.272 | -0.511 | -0.540 | -0.414 | -0.478 | 0.395 | 0.374 | 0.623 | -0.396 | 1.000 |
| Any_Feat_pct_ACV | -0.832 | -0.250 | -0.183 | 0.571 | 0.571 | 0.294 | 0.287 | -0.600 | 0.400 | -0.210 | 0.400 | -0.015 | -0.434 | -0.566 | 0.769 | 0.734 | -0.385 | -0.663 | -0.021 | -0.503 | 1.000 | -0.383 | 0.154 | -0.790 | -0.636 | -0.629 | 0.392 | -0.364 | 0.143 | -0.452 | -0.112 | -0.161 | 0.224 | -0.378 | -0.629 | -0.503 | 0.510 | -0.273 | 1.000 |
| Any_Disp_pct_ACV | 0.160 | 0.325 | 0.371 | -0.110 | -0.223 | 0.044 | 0.052 | -0.430 | -0.429 | -0.019 | 0.154 | -0.154 | 0.432 | 0.235 | 0.012 | -0.073 | 0.067 | -0.375 | -0.599 | 0.333 | -0.383 | 1.000 | -0.512 | -0.078 | -0.106 | 0.329 | 0.201 | -0.422 | -0.152 | 0.115 | -0.618 | -0.377 | -0.424 | -0.402 | 0.364 | 0.358 | 0.159 | -0.349 | 1.000 |
| EQ_Base_Price | -0.241 | 0.053 | 0.039 | 0.374 | 0.571 | 0.366 | 0.453 | -0.650 | -0.600 | 0.092 | -0.489 | 0.276 | -0.104 | -0.173 | 0.094 | 0.181 | -0.527 | 0.385 | 0.757 | -0.360 | 0.154 | -0.512 | 1.000 | -0.154 | -0.120 | -0.120 | -0.041 | 0.650 | 0.209 | -0.454 | 0.802 | 0.361 | 0.576 | 0.641 | -0.196 | -0.177 | -0.114 | 0.629 | 1.000 |
| Est_ACV_Selling | 0.863 | -0.089 | -0.163 | -0.480 | -0.739 | -0.746 | -0.685 | -0.392 | -0.150 | -0.164 | -0.522 | 0.300 | -0.087 | 0.007 | -0.921 | -0.734 | 0.537 | 0.526 | -0.101 | 0.228 | -0.790 | -0.078 | -0.154 | 1.000 | 0.981 | 0.605 | 0.129 | 0.187 | -0.736 | -0.055 | 0.086 | -0.122 | -0.169 | 0.088 | 0.252 | 0.121 | 0.122 | 0.265 | 1.000 |
| pct_ACV | 0.867 | -0.067 | -0.118 | -0.489 | -0.755 | -0.744 | -0.683 | -0.476 | -0.283 | -0.137 | -0.467 | 0.281 | -0.042 | 0.011 | -0.905 | -0.728 | 0.527 | 0.548 | -0.067 | 0.243 | -0.636 | -0.106 | -0.120 | 0.981 | 1.000 | 0.591 | 0.126 | 0.235 | -0.621 | -0.138 | 0.110 | -0.126 | -0.133 | 0.151 | 0.274 | 0.144 | 0.102 | 0.325 | 1.000 |
| Avg_no_of_Items | 0.767 | 0.389 | 0.315 | -0.381 | -0.391 | -0.375 | -0.324 | -0.077 | -0.117 | 0.080 | -0.192 | 0.303 | 0.169 | 0.259 | -0.560 | -0.393 | 0.215 | 0.257 | -0.315 | 0.451 | -0.629 | 0.329 | -0.120 | 0.605 | 0.591 | 1.000 | 0.427 | -0.099 | -0.143 | -0.223 | -0.197 | -0.382 | -0.302 | -0.114 | 0.407 | 0.348 | 0.294 | 0.014 | 1.000 |
| pct_PromoMarketDollars_Category | 0.446 | -0.082 | -0.205 | -0.171 | -0.248 | -0.034 | 0.011 | -0.427 | -0.300 | -0.131 | 0.016 | -0.126 | -0.167 | 0.224 | -0.115 | 0.093 | -0.119 | -0.095 | -0.520 | 0.713 | 0.392 | 0.201 | -0.041 | 0.129 | 0.126 | 0.427 | 1.000 | -0.535 | 0.187 | -0.316 | -0.420 | -0.514 | -0.395 | -0.531 | 0.169 | 0.151 | 0.930 | -0.487 | 1.000 |
| RPI_Category | -0.058 | 0.260 | 0.303 | 0.335 | 0.273 | 0.037 | 0.084 | -0.399 | -0.367 | 0.221 | -0.434 | 0.242 | 0.162 | -0.237 | -0.219 | -0.288 | -0.081 | 0.512 | 0.847 | -0.478 | -0.364 | -0.422 | 0.650 | 0.187 | 0.235 | -0.099 | -0.535 | 1.000 | -0.220 | -0.094 | 0.889 | 0.559 | 0.667 | 0.910 | 0.027 | -0.009 | -0.559 | 0.966 | 1.000 |
| Magazine_Impressions_pct | -0.489 | 0.095 | 0.524 | 0.505 | 0.615 | 0.659 | 0.604 | 0.190 | 0.143 | 0.038 | 0.771 | 0.283 | 0.294 | 0.560 | 0.363 | 0.516 | -0.522 | -0.562 | 0.115 | -0.341 | 0.143 | -0.152 | 0.209 | -0.736 | -0.621 | -0.143 | 0.187 | -0.220 | 1.000 | 0.341 | -0.088 | -0.016 | 0.110 | 0.082 | -0.126 | 0.077 | 0.027 | -0.225 | 1.000 |
| TV_GRP | -0.143 | 0.452 | 0.738 | 0.223 | 0.116 | 0.239 | 0.094 | 0.619 | 0.086 | 0.267 | 0.657 | -0.179 | 0.092 | 0.319 | 0.201 | -0.063 | 0.069 | -0.165 | -0.110 | 0.272 | -0.452 | 0.115 | -0.454 | -0.055 | -0.138 | -0.223 | -0.316 | -0.094 | 0.341 | 1.000 | -0.253 | 0.110 | -0.025 | -0.003 | 0.421 | 0.506 | -0.404 | -0.055 | 1.000 |
| Competitor1_RPI | -0.198 | 0.082 | 0.074 | 0.301 | 0.346 | 0.109 | 0.173 | -0.580 | -0.600 | 0.138 | -0.324 | 0.217 | -0.170 | -0.362 | -0.127 | -0.090 | -0.220 | 0.456 | 0.943 | -0.511 | -0.112 | -0.618 | 0.802 | 0.086 | 0.110 | -0.197 | -0.420 | 0.889 | -0.088 | -0.253 | 1.000 | 0.597 | 0.762 | 0.846 | -0.253 | -0.256 | -0.406 | 0.841 | 1.000 |
| Competitor2_RPI | -0.442 | -0.195 | -0.109 | 0.135 | 0.197 | 0.007 | -0.001 | -0.056 | -0.200 | 0.210 | 0.297 | -0.042 | -0.236 | -0.370 | 0.048 | -0.076 | -0.057 | 0.000 | 0.713 | -0.540 | -0.161 | -0.377 | 0.361 | -0.122 | -0.126 | -0.382 | -0.514 | 0.559 | -0.016 | 0.110 | 0.597 | 1.000 | 0.612 | 0.572 | -0.475 | -0.466 | -0.355 | 0.439 | 1.000 |
| Competitor3_RPI | -0.376 | 0.059 | 0.099 | 0.230 | 0.307 | 0.174 | 0.196 | -0.182 | -0.367 | 0.117 | -0.027 | -0.058 | -0.240 | -0.415 | 0.140 | 0.047 | -0.273 | -0.029 | 0.819 | -0.414 | 0.224 | -0.424 | 0.576 | -0.169 | -0.133 | -0.302 | -0.395 | 0.667 | 0.110 | -0.025 | 0.762 | 0.612 | 1.000 | 0.768 | -0.358 | -0.302 | -0.372 | 0.588 | 1.000 |
| Competitor4_RPI | -0.141 | 0.216 | 0.296 | 0.264 | 0.274 | 0.107 | 0.141 | -0.189 | -0.233 | 0.093 | -0.187 | 0.255 | 0.079 | -0.267 | -0.130 | -0.131 | -0.137 | 0.437 | 0.882 | -0.478 | -0.378 | -0.402 | 0.641 | 0.088 | 0.151 | -0.114 | -0.531 | 0.910 | 0.082 | -0.003 | 0.846 | 0.572 | 0.768 | 1.000 | -0.108 | -0.113 | -0.540 | 0.877 | 1.000 |
| EQ_Category | 0.545 | 0.687 | 0.579 | 0.164 | -0.017 | -0.008 | 0.024 | 0.140 | 0.133 | -0.047 | -0.412 | 0.028 | 0.793 | 0.571 | -0.141 | -0.229 | 0.068 | 0.158 | -0.374 | 0.395 | -0.629 | 0.364 | -0.196 | 0.252 | 0.274 | 0.407 | 0.169 | 0.027 | -0.126 | 0.421 | -0.253 | -0.475 | -0.358 | -0.108 | 1.000 | 0.975 | -0.089 | 0.151 | 1.000 |
| EQ_Subcategory | 0.439 | 0.642 | 0.567 | 0.270 | 0.132 | 0.119 | 0.146 | 0.217 | 0.167 | -0.038 | -0.368 | -0.011 | 0.798 | 0.592 | -0.001 | -0.127 | -0.023 | 0.061 | -0.347 | 0.374 | -0.503 | 0.358 | -0.177 | 0.121 | 0.144 | 0.348 | 0.151 | -0.009 | 0.077 | 0.506 | -0.256 | -0.466 | -0.302 | -0.113 | 0.975 | 1.000 | -0.126 | 0.117 | 1.000 |
| pct_PromoMarketDollars_Subcategory | 0.328 | -0.208 | -0.328 | -0.295 | -0.385 | -0.111 | -0.082 | -0.587 | -0.450 | -0.118 | 0.297 | -0.204 | -0.387 | 0.015 | -0.135 | 0.072 | -0.071 | -0.133 | -0.465 | 0.623 | 0.510 | 0.159 | -0.114 | 0.122 | 0.102 | 0.294 | 0.930 | -0.559 | 0.027 | -0.404 | -0.406 | -0.355 | -0.372 | -0.540 | -0.089 | -0.126 | 1.000 | -0.559 | 1.000 |
| RPI_Subcategory | 0.068 | 0.314 | 0.359 | 0.318 | 0.250 | 0.019 | 0.086 | -0.490 | -0.467 | 0.240 | -0.495 | 0.266 | 0.240 | -0.147 | -0.273 | -0.362 | -0.057 | 0.541 | 0.758 | -0.396 | -0.273 | -0.349 | 0.629 | 0.265 | 0.325 | 0.014 | -0.487 | 0.966 | -0.225 | -0.055 | 0.841 | 0.439 | 0.588 | 0.877 | 0.151 | 0.117 | -0.559 | 1.000 | 1.000 |
| Period | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 | 1.000 |
| Period | EQ | Social_Search_Impressions | Social_Search_Working_cost | Digital_Impressions | Digital_Working_cost | Print_Impressions.Ads40 | Print_Working_Cost.Ads50 | OOH_Impressions | OOH_Working_Cost | SOS_pct | Digital_Impressions_pct | CCFOT | Median_Temp | Median_Rainfall | Fuel_Price | Inflation | Trade_Invest | Brand_Equity | Avg_EQ_Price | Any_Promo_pct_ACV | Any_Feat_pct_ACV | Any_Disp_pct_ACV | EQ_Base_Price | Est_ACV_Selling | pct_ACV | Avg_no_of_Items | pct_PromoMarketDollars_Category | RPI_Category | Magazine_Impressions_pct | TV_GRP | Competitor1_RPI | Competitor2_RPI | Competitor3_RPI | Competitor4_RPI | EQ_Category | EQ_Subcategory | pct_PromoMarketDollars_Subcategory | RPI_Subcategory | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2016 - Period:1 | 504.784933 | NaN | NaN | 37148.2 | 2045.28200 | NaN | NaN | NaN | NaN | 7.446883 | NaN | 100.000000 | 32.950 | 0.5150 | 8.226 | 0.013258 | 42744.25684 | 42.410000 | 49.091447 | 9.691794 | NaN | 1.688896 | 1.427532 | 8.696588e+09 | 39.441025 | 2.611782 | 0.03390 | 35.817030 | NaN | NaN | 97.173365 | 35.557371 | 44.502717 | 63.377268 | 1728388.673 | 331927.5394 | 0.162732 | 40.560563 |
| 1 | 2016 - Period:2 | 490.226477 | NaN | NaN | 50886.8 | 2370.58400 | 0.000014 | 0.000015 | NaN | NaN | 11.677082 | NaN | 87.500000 | 34.625 | 0.2700 | 7.473 | 0.009938 | 36290.43956 | 42.410000 | 49.057612 | 9.415938 | NaN | 1.687952 | 1.442716 | 8.682307e+09 | 38.417224 | 2.522814 | 0.03910 | 36.389065 | NaN | NaN | 97.850760 | 37.223072 | 45.720077 | 62.731742 | 1900859.879 | 334611.3806 | 0.231650 | 40.046301 |
| 2 | 2016 - Period:3 | 479.244686 | NaN | NaN | 253333.2 | 3180.88800 | 0.000016 | 0.000017 | NaN | NaN | 0.102858 | NaN | 96.000000 | 46.700 | 0.3900 | 8.001 | 0.007832 | 34852.14166 | 42.410000 | 49.367514 | 5.176684 | NaN | NaN | 1.423408 | 8.706898e+09 | 36.499442 | 2.477322 | 0.02280 | 36.599984 | NaN | NaN | 96.397739 | 40.800563 | 41.822953 | 62.090417 | 2036436.906 | 387148.3582 | 0.125394 | 40.411115 |
| 3 | 2016 - Period:4 | 489.057428 | NaN | NaN | 3426239.0 | 13595.39800 | 0.000016 | 0.000019 | NaN | NaN | 0.249055 | NaN | 100.000000 | 49.650 | 0.3500 | 8.767 | 0.010034 | 24869.55899 | 43.543571 | 50.657634 | 6.088273 | NaN | NaN | 1.443401 | 8.660289e+09 | 38.135159 | 2.520409 | 0.01470 | 38.201852 | NaN | NaN | 98.936519 | 36.576140 | 41.578429 | 63.374358 | 2113635.013 | 482489.6740 | 0.056603 | 42.213246 |
| 4 | 2016 - Period:5 | 477.031994 | NaN | NaN | 552197.8 | 3983.13400 | 0.000016 | 0.000019 | NaN | NaN | 13.338804 | NaN | 100.000000 | 58.100 | 0.5025 | 9.277 | 0.009546 | 61675.32162 | 43.790000 | 50.625777 | 7.827112 | NaN | 0.170731 | 1.473687 | 8.644519e+09 | 38.629564 | 2.497285 | 0.02190 | 38.648805 | 31.702433 | 25.3 | 100.509969 | 36.032016 | 42.602412 | 63.291934 | 2402211.102 | 629826.6484 | 0.065059 | 43.345578 |
| 5 | 2016 - Period:6 | 487.855299 | NaN | NaN | 29892.2 | 1800.34400 | 0.000017 | 0.000020 | NaN | NaN | 13.562212 | NaN | 78.571429 | 68.500 | 0.4600 | 9.824 | 0.009290 | 40458.59237 | 43.790000 | 51.268984 | 9.791997 | 1.633989 | NaN | 1.457055 | 8.627353e+09 | 39.097729 | 2.455277 | 0.01070 | 39.305958 | 40.158646 | 47.7 | 99.796505 | 36.996437 | 44.943022 | 68.415943 | 2796949.720 | 806075.7642 | 0.029912 | 44.075674 |
| 6 | 2016 - Period:7 | 466.399281 | NaN | NaN | 6021768.0 | 7591.64400 | 0.000017 | 0.000020 | NaN | NaN | 14.392305 | NaN | 88.000000 | 73.700 | 0.4250 | 9.642 | 0.008284 | 40945.74781 | 44.007143 | 50.676333 | 8.802657 | NaN | NaN | 1.437953 | 8.662699e+09 | 39.017768 | 2.412757 | 0.00765 | 39.653897 | 31.039855 | 44.7 | 101.096185 | 37.314308 | 43.358409 | 65.420869 | 2867306.933 | 828776.1488 | 0.021788 | 45.072822 |
| 7 | 2016 - Period:8 | 546.053084 | NaN | NaN | 1815307.2 | 7866.57200 | 0.000017 | 0.000020 | NaN | NaN | 15.376127 | NaN | 84.615385 | 77.350 | 0.5550 | 9.148 | 0.008461 | 22026.52625 | 44.170000 | 48.992972 | 13.660056 | 5.136756 | 7.925424 | 1.453832 | 8.511934e+09 | 37.940027 | 2.641764 | 0.03020 | 38.322539 | 32.195566 | 32.0 | 94.654006 | 34.013304 | 41.356740 | 64.478960 | 2813494.081 | 789109.5698 | 0.093287 | 42.974524 |
| 8 | 2016 - Period:9 | 464.925607 | NaN | NaN | 153633.2 | 3579.13000 | 0.000017 | 0.000020 | NaN | NaN | 22.932534 | NaN | 100.000000 | 75.850 | 0.5600 | 9.225 | 0.011022 | 53214.88476 | 44.170000 | 49.308852 | 9.791260 | 5.154291 | 3.894864 | 1.476185 | 7.928217e+09 | 35.696189 | 2.559809 | 0.03040 | 38.110967 | 38.002816 | 16.5 | 96.238963 | 37.377758 | 40.577016 | 63.264193 | 2441916.655 | 606656.5082 | 0.100700 | 42.760786 |
| 9 | 2016 - Period:10 | 357.648693 | 3919100.6 | 24839.812 | 30331.0 | 23205.98871 | 0.000017 | 0.000020 | NaN | NaN | 28.529493 | NaN | 100.000000 | 71.050 | 0.2950 | 9.331 | 0.013966 | 25343.21025 | 44.207143 | 54.138214 | 6.060160 | NaN | 0.147772 | 1.525389 | 7.765786e+09 | 32.618780 | 2.664421 | 0.00561 | 39.595750 | NaN | NaN | 105.031551 | 46.598751 | 44.631443 | 67.040049 | 2017353.844 | 421134.3688 | 0.025271 | 43.925962 |
| Period | EQ | Social_Search_Impressions | Social_Search_Working_cost | Digital_Impressions | Digital_Working_cost | Print_Impressions.Ads40 | Print_Working_Cost.Ads50 | OOH_Impressions | OOH_Working_Cost | SOS_pct | Digital_Impressions_pct | CCFOT | Median_Temp | Median_Rainfall | Fuel_Price | Inflation | Trade_Invest | Brand_Equity | Avg_EQ_Price | Any_Promo_pct_ACV | Any_Feat_pct_ACV | Any_Disp_pct_ACV | EQ_Base_Price | Est_ACV_Selling | pct_ACV | Avg_no_of_Items | pct_PromoMarketDollars_Category | RPI_Category | Magazine_Impressions_pct | TV_GRP | Competitor1_RPI | Competitor2_RPI | Competitor3_RPI | Competitor4_RPI | EQ_Category | EQ_Subcategory | pct_PromoMarketDollars_Subcategory | RPI_Subcategory | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 994 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 995 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 996 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 997 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 998 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 999 | 2017 - Period:1 | 392.326431 | 1314877.0 | 7398.658606 | NaN | NaN | 1.666660e-05 | 0.000020 | NaN | NaN | 0.280502 | NaN | 100.000000 | 35.45 | 0.4700 | 9.884 | 0.022581 | 657.53 | 44.45 | 50.923311 | 8.566851 | 5.581585 | NaN | 1.587163 | 7.410278e+09 | 32.390628 | 2.579821 | 0.06040 | 36.430769 | NaN | NaN | 98.351850 | 35.773009 | 42.782645 | 65.403281 | 1696093.627 | 312550.9088 | 0.384183 | 40.624048 |
| 1000 | 2017 - Period:6 | 300.922056 | 21830378.8 | 98309.553500 | 7324082.2 | 111398.20310 | 1.059535e+07 | 239751.406700 | 1.306122e+08 | 1.361008e+05 | 11.999073 | 0.045347 | 100.000000 | 67.60 | 0.4550 | 10.030 | 0.015872 | 390.58 | 43.85 | 57.957097 | 7.990102 | NaN | NaN | 1.647474 | 5.537742e+09 | 23.778706 | 2.509645 | 0.00990 | 44.150672 | 39.492174 | 32.1 | 116.098715 | 37.773410 | 53.149560 | 76.896817 | 2674460.512 | 818710.9650 | 0.024751 | 49.735737 |
| 1001 | 2018 - Period:1 | 247.315476 | 2829923.6 | 9938.170001 | NaN | NaN | 1.484088e+04 | 1618.587524 | NaN | NaN | 24.443994 | NaN | 83.333333 | 29.95 | 0.1550 | 10.633 | 0.018029 | 571.28 | 42.78 | 54.551107 | 6.823758 | NaN | 0.294481 | 1.730202 | 4.723807e+09 | 20.495015 | 2.442941 | 0.05460 | 38.676377 | NaN | NaN | 107.289052 | 39.953699 | 49.153589 | 65.064755 | 1645094.597 | 320624.4770 | 0.313571 | 42.670532 |
| 1002 | 2018 - Period:6 | 278.317524 | 15378465.6 | 58338.893120 | 5454810.0 | 74906.49837 | 1.519706e+02 | 50.580880 | NaN | NaN | 0.408558 | 17.468517 | 100.000000 | 71.40 | 0.5725 | 12.045 | 0.026145 | 1168.95 | 42.33 | 46.623404 | 8.972687 | NaN | 1.761352 | 1.473754 | 3.397925e+09 | 14.081542 | 2.447068 | 0.03030 | 35.062487 | NaN | NaN | 90.388998 | 34.106909 | 41.091068 | 58.301021 | 2715526.999 | 798281.1536 | 0.078074 | 38.517608 |
| 1003 | 2018 - Period:11 | 161.529279 | 285755.2 | 5232.968000 | 63120.8 | NaN | 1.929363e+06 | 24347.693170 | 1.693330e+09 | 2.115462e+06 | 3.492029 | 0.059827 | 82.653061 | 49.40 | 0.3000 | 11.766 | 0.022503 | 2461.60 | 42.14 | 53.438223 | 1.775007 | NaN | 1.087742 | 1.493424 | 3.214808e+09 | 13.676382 | 2.247411 | 0.00131 | 37.871237 | NaN | NaN | 100.734978 | 37.813696 | 45.792891 | 65.671466 | 1628818.628 | 329510.9938 | 0.006405 | 40.955281 |
Most frequently occurring
| Period | EQ | Social_Search_Impressions | Social_Search_Working_cost | Digital_Impressions | Digital_Working_cost | Print_Impressions.Ads40 | Print_Working_Cost.Ads50 | OOH_Impressions | OOH_Working_Cost | SOS_pct | Digital_Impressions_pct | CCFOT | Median_Temp | Median_Rainfall | Fuel_Price | Inflation | Trade_Invest | Brand_Equity | Avg_EQ_Price | Any_Promo_pct_ACV | Any_Feat_pct_ACV | Any_Disp_pct_ACV | EQ_Base_Price | Est_ACV_Selling | pct_ACV | Avg_no_of_Items | pct_PromoMarketDollars_Category | RPI_Category | Magazine_Impressions_pct | TV_GRP | Competitor1_RPI | Competitor2_RPI | Competitor3_RPI | Competitor4_RPI | EQ_Category | EQ_Subcategory | pct_PromoMarketDollars_Subcategory | RPI_Subcategory | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | 965 |